Sign Up Login


  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

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

Explain the architecture of ms sql reporting service?

0 Answers  

What are scalar functions?

0 Answers  

What is the difference between TRUNCATE and DROP?

0 Answers  

What are the advantages of user defined function?

0 Answers  




What is the importance of concurrency control?

0 Answers  

How do I open a .db file?

0 Answers  

What is log cache in sql server?

0 Answers  

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

How to join two tables in a single query in ms sql server?

0 Answers  

What is an indexing technique?

0 Answers  

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories