User Id :    Password :      New Member   Forgot Password  
Topic: Where to use UPDATE STATISTICS in SQL
Sachin Jain
29 Oct 2010 at 10:59 PM
Where to use UPDATE STATISTICS in SQL.
Re: Where to use UPDATE STATISTICS in SQL
Gaurav
01 Nov 2010 at 12:28 AM

This command mainly is used when we have to process large amount of data. 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.

Total Replies: 1
 
Featured Text Ad

Featured Ad