Interested to Buy Any Domain ? << Click Here >> for more details...
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 partitioned view?
Is mysql better than sql server?
What are various aggregate functions that are available?
Define compound operators?
What is the difference between composite index and covering index?
What will happen if a column containing char type data is changed to the nchar data type?
What do you understand by coalesce in sql server?
What is identity?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What does the on update no action do?
What is the maximum row of a size?
Why use sub query in sql server and list out types of sub queries?
How many types of triggers are there?
How to transfer data from a cursor to variables with a "fetch" statement?
