What is the purpose of UPDATE STATISTICS?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the default system databases in sql server 2000?

688


Why we use functions in sql server?

719


What happens if you add a new index to large table?

682


Does full backup break log chain?

733


Which autogrowth database setting is good?

790






What is hot add cpu in sql server 2008?

702


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

724


How to drop an existing table with "drop table" statements in ms sql server?

729


How many triggers you can have on a table?

700


What are the types of processing and explain each? : sql server analysis services, ssas

904


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

795


Is foreign key unique?

750


How ssrs maintain security?

778


What is difference between unique and primary key?

651


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

700