When do we use the UPDATE_STATISTICS command?

Answer Posted / govind

its used to create auto indexes on table. means non
clustred indexes are created on table.which is used to
easily craeted data pages for modification and deleteion.

Is This Answer Correct ?    5 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if no size is defined while creating the database, what size will the database have? : Sql server administration

542


How to download and install sql server 2005 books online?

539


What are the authentication modes in sql server? How can it be changed?

595


wat wil hapn if we give the both read and deny read permission to user?

1653


What is change data capture (cdc) feature?

584






What are the characteristics of modern DBMS?

619


What do you need to connect php to sql server?

535


Can we install sql server 2016 on windows 7?

666


What are the rendering extensions of ssrs?

105


Which language is supported by sql server?

553


How to rename databases in ms sql server?

619


Explain sql server service broker?

510


What are the tool windows in sql server management studio? : sql server management studio

620


What are cursors stored procedures and triggers?

513


Explain how to use linked server?

560