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
plss anybody specify tha constrian management system in dbms
Why use triggers?
How to create new databases with "create database" statements?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How can you know if the row fetched from cursor is still valid in underlying table?
How to disconnect from a sql server using mssql_close()?
What are the different types of backups that exist?
How many full-text indexes can a table have?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How to provide login information for a new odbc dsn?
What is 3nf normalization?
What do we have to check in database testing?
How to make a remote connection in a database?
Who developed sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security