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
How can we delete Duplicate row in table?
What is the purpose of a table?
What is normalization process?
What is a covering index?
Define left outer join?
Can a table be created inside a trigger?
What do you understand by triggers and mention the different types of it?
Explain the difference between HTTP and HTTPS in database?
Explain transaction isolation levels in sql server?
What is 2nf normalization?
What is the difference between count () and rowcount ()?
Explain how to integrate the ssrs reports in application?
How you would rewrite the sql query to return the customerid sorted numerically?
What are the differences between triggers and stored procedures?
what is a traditional network library for sql servers? : Sql server database administration