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.
Liked By
Write Answer
When is the UPDATE_STATISTICS command used?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
12-Oct-2014When 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.