Home > DeveloperSection > Interviews > When is the UPDATE_STATISTICS command used?

Posted on    October-12-2014 10:57 PM

 MSSQL Server Database  MSSQL Server 
 1 Answer(s)
  993  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Posted on    October-12-2014 10:57 PM

When the processing of large data is done, this command is used. 
Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.

Don't want to miss updates? Please click the below button!

Follow MindStick