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

How to verify a login name with sqlcmd tool?

599


in the physical file layout, where should the transaction log be stored in relation to the data file?

541


Which autogrowth database setting is good?

625


How to drop an existing schema in ms sql server?

599


List down some advantages of sql stored procedure?

568






Tell me something about security and sql azure?

104


What is sub query and its properties?

551


What are the events recorded in a transaction log?

511


What stored by the model? : sql server database administration

551


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

573


How except clause is differs from not in clause?

540


How to generate create table script on an existing table in ms sql server?

651


What is a covering index?

538


What is acid properties?

597


Does index slows down insert statements?

589