Interview Questions - When is the use of UPDATE_STATISTICS command?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

When is the use of UPDATE_STATISTICS command?

May 16 2012 12:00AM by Nirav Gandhi

Question

When is the use of UPDATE_STATISTICS command?

Answer

This command is basically used when a large processing of data has occurred. If a large amount of deletions any modification or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

Read More.. [98 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: What is difference between STUFF and REPLACE in SQL Server?
Next: What is the use of SQL Server Browser ?

Nirav Gandhi

38 · 5% · 1503

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"When is the use of UPDATE_STATISTICS command?" rated 5 out of 5 by 3 readers

When is the use of UPDATE_STATISTICS command?

Question

Answer

Your Comment