Answer Posted / rajesh ranjan
Hi
This command is basically used when a large processing of
data has occurred. 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.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is create command?
What is raiseerror? What is raiseerror?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Can we use where and having clause together?
What is user-defined inline table-valued function?
What is 3nf normalization?
Where is trigger in sql server?
What is ems sql management studio? : sql server management studio
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Explain how you can deploy an SSRS report?
explain different levels of normalization? : Sql server database administration
What is change tracking in sql server?
How do I find the sql server instance name?
How real and float literal values are rounded?
What is bulkcopy in sql?