What are statistics, under what circumstances they go out
of date, how do you update them?
Answer Posted / swapna
Statistics determine the selectivity of the indexes. If an
indexed column has unique values then the selectivity of
that index is more, as opposed to an index with non-unique
values. Query optimizer uses these indexes in determining
whether to choose an index or not while executing a query.
Some situations under which you should update statistics:
1) If there is significant change in the key values in the
index
2) If a large amount of data in an indexed column has been
added, changed, or removed (that is, if the distribution of
key values has changed), or the table has been truncated
using the TRUNCATE TABLE statement and then repopulated
3) Database is upgraded from a previous version
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is normalization and what are the advantages of it?
What are truncate options available in sql server? : sql server database administration
What are the types of dml?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How do I start sql server agent automatically?
what information is maintained within the msdb database? : Sql server administration
What is the maximum size per database for sql server express?
How to make a column nullable?
What stored by the model?
How to find the second highest salary of an employee?
Explain how to integrate the ssrs reports in application?
Describe triggers features and limitations?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is usually the first word in a sql query?
Describe in brief system database.