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

We need to perform what steps in the following order to work with a cursor?

720


What is difference between line feed ( ) and carriage return ( )?

528


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

518


What is the sql case statement used for? Explain with an example?

544


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

639






can we have a nested transaction? : Sql server database administration

509


Does partitioning improve performance?

494


what information is maintained within the msdb database? : Sql server administration

511


Where are stored procedures in sql server?

566


what are database files and filegroups? : Sql server database administration

505


How to optimize stored procedure optimization?

521


Mention what are the core components of ssrs?

208


What is temporary table in sql server? Why we use temp table?

523


Can we check locks in database? If so, how can we do this lock check?

533


Explain difference between cross join and full outer join?

566