What is the purpose of UPDATE STATISTICS?

Answer Posted / sambashiva

This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is join query?

667


What is default constraint in ms sql server?

712


Which are the olap features?

741


What happens if time-only values are provided as date and time literals?

727


how many clustered indexes can be created on a table? : Sql server database administration

779






Are all views updatable ?

892


Write query to return all rows sql?

792


How do you rebuild an identity column?

716


What is recompile sql server?

756


What are the database objects? : SQL Server Architecture

704


Explain cdc and sql injection?

718


Can coalesce return null?

730


Explain features of analysis services?

690


What is a heap?

783


Different types of keys in SQL?

823