When do we use the UPDATE_STATISTICS command?
Answer Posted / guest
This command is basically used when we do a large processing
of data. If we do a large amount of deletions any
modification or Bulk Copy into the tables, we need to
basically update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.
| Is This Answer Correct ? | 34 Yes | 6 No |
Post New Answer View All Answers
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How exceptions can be handled in sql server programming?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is best institute to Learn DotNET And SQL in chennai?
What are a scheduled jobs or what is a scheduled tasks?
How do you trace the traffic hitting a sql server?
 Explain what is sql override for a source taLle in a mapping?
Explain concepts of analysis services?
What are the disadvantages of using querystrings to send data from one page to another?
What are the types of database schema? : sql server analysis services, ssas
How to perform backup for certificates in sql server? : sql server security
What is parameterized reports in ssrs ?
How to find the login name linked to a given user name?
What are the components of dbms?