Interested to Buy Any Domain ? << Click Here >> for more details...
What are statistics, under what circumstances they go out
of date, how do you update them?
- 2 Answers
- 9004 Views
- HCL, I also Faced
- E-Mail Answers
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
How to connect ms access to sql servers through odbc?
What does it mean if @@cursor_row returns a negative number?
What is the difference between a unique key and primary key?
Explain what are commit and rollback in sql?
Where are full-text indexes stored?
Do you know what are the restrictions that views have to follow?
What is self contained scalar sub query?
How does normalization work?
What is the difference between nvl and nvl2?
How to create a view with data from multiple tables?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are the purposes and advantages stored procedure?
What is the cpu pressure?
What are the different ways you can create databases in sql server?
What is order of B+tree?
