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
Differentiate sql server reporting services vs. Crystal reports?
Can you please differentiate between a primary key and a unique key?
 Explain what is sql override for a source taLle in a mapping?
What is 1nf 2nf?
What is the difference between NOROW and LOCKROW?
How to download and install the scaled-down database adventureworkslt?
Tell me in brief how sql server enhances scalability of the database system?
What is join query?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
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?
Explain transaction server explicit transaction?
How to resolve the orphan use problem? : sql server security
What program is used to store the data source file?
What are relationships and mention different types of relationships in the dbms
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas