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 the use of sign function?

563


What is the report builder?

106


Which are the olap features?

552


How can I check if a view exists in a sql server database?

567


Difference between Logical Page and Physical Page in SSRS.

340






Your table has a large character field there are queries that use this field in their search clause what should you do?

506


Does a sql server 2005 select statement require a from?

587


How do I find the default sql server instance?

528


What is the difference between locking and multi-versioning?

540


How display code or Text of Stored Procedure using Sql query in Sql Server ?

613


What is the command used to check locks in microsoft sql server?

547


What is the difference between a primary key and a unique key? Are they the same?

550


What is normalization of database?

607


Explain how you can configure a running aggregate in SSRS?

111


Do you know what is difference between index seek vs. Index scan?

523