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

Explain what are magic tables in sql server?

0 Answers  

Can two tables have the same primary key?

0 Answers  

What is a data source or ds? : sql server analysis services, ssas

0 Answers  

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  




Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

what is a join? : Sql server database administration

0 Answers  

How to skip remaining statements in a loop block using continue statements?

0 Answers  

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

what command is used to create a table by copying the structure of another table?

7 Answers  

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

What is an entity-relationship diagram (erd)?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories