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

Tell me what is log shipping?

575


Do comments need to go in a special place in sql server 2005?

519


last function used in MS Access to convert sql what function will use in sql

1612


How do I find the transaction log size in sql server?

523


Explain the concept of view and Types of views in SQL server?

623






Can we hide the definition of a stored procedure from a use?

660


How to filter out duplications in the returning rows in ms sql server?

644


What is resource db in sql server?

604


What is the main purpose of having conversation group?

502


Explain transaction server consistency?

530


Explain what is the use of custom fields in report?

506


Can we use where clause with group by?

524


How to populate a table in sql server?

509


Define a cross join?

598


What are the types of user defined functions in sql server?

509