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
Are null values the same as that of zero or a blank space?
What is the recommended total size of your memory optimized tables?
What are the types of containers in ssis?
What is the command dbcc checkdb used for?
how to use DTS package in 2000,2005,2008 in sql server
What are commonly used odbc functions in php?
What are null values in ms sql server?
Explain the difference between delete,drop and truncate in SQL Server?
What is the name of the Database which IBM mainframe uses?
What is the default sql server instance name?
How to create a user to access a database in ms sql server using "create user" statements?
Differentiate sql server reporting services vs. Crystal reports?
How to find index size for each index on table?
What is the difference between DATETIME2 and DATETIME?
What are SSL and TSL protocols?
