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 to replace the Query Result 'Null Value' with a text ?
How do I create a stored procedure in dbml?
What stored by the msdb? : sql server database administration
How will you find out if there are expensive SQL statements running or not?
What is the difference between Triggers and Stored Procedure?
Define outer join in sql server joins?
Why use identity in sql server?
Which tcp/ip port does sql server run on? How can it be changed?
Which sql server table is used to hold the stored procedure scripts?
What is left outer join in sql server joins?
How each E-R model constructs can be mapped to the relational model?
What are three major types of constraints?
Tell me what is de-normalization and what are some of the examples of it?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How can we remove orphan records from a table?