1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the purpose of UPDATE STATISTICS?

Question Posted / latha sree

Answers were Sorted based on User's Feedback



What is the purpose of UPDATE STATISTICS?..

Answer / guest

Updates information about the distribution of key values for
one or more statistics groups (collections) in the specified
table or indexed view.

Is This Answer Correct ?    8 Yes 3 No

What is the purpose of UPDATE STATISTICS?..

Answer / 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

More SQL Server Interview Questions

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

Why main is user defined function?

0 Answers  

what protocol both networks use? : Sql server database administration

0 Answers  

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  




What stored by the master?

0 Answers  

What are views in ms sql server?

0 Answers  

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

Explain query editor regions

0 Answers  

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

Explain subquery and state its properties?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories