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
optimization techinques
Is port 1433 secure?
What is rtm version in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What are the properties of the transaction?
Is resultset an interface?
Explain timestamp datatype?
What are the steps you will take to improve the performance of a poor performing query?
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?
What are the difference between primary keys and foreign keys?
What is meant by referential integrity?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is best institute to Learn DotNET And SQL in chennai?
What is an example of a primary key?
What is primary key and example?