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 a hint?
What is tablix?
Explain few examples of RDBMS?
Difference between drill down and drill through report.
How you can minimize the deadlock situation?
What happens if null values are involved in string operations?
How many replicas are maintained for each sql azure db?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How do you rename a table in sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
Do you know what is openxml in sql server?
Can two tables share a primary key?
What are data files?
Explain having clause and where clause?
Can we add an identity column to decimal datatype?
