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

optimization techinques

2409


Is port 1433 secure?

749


What is rtm version in sql server?

716


Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

129


What are the properties of the transaction?

750


Is resultset an interface?

727


Explain timestamp datatype?

725


What are the steps you will take to improve the performance of a poor performing query?

773


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

728


What are the difference between primary keys and foreign keys?

721


What is meant by referential integrity?

762


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

719


What is best institute to Learn DotNET And SQL in chennai?

1918


What is an example of a primary key?

706


What is primary key and example?

714