WHEN IS THE UPDATE_STATISTICS COMMAND USED?

Kamlakar Singh

Total Post:80

Points:400
Posted by  Kamlakar Singh
 1031  View(s)
Ratings:
Rate this:
  1. Kamlakar Singh

    Post:80

    Points:400
    When is the UPDATE_STATISTICS command used?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!