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
- 9009 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
State the difference between local and global temporary tables?
How to convert numeric expression data types using the cast() function?
What are rest-style architecture's?
what is the sql equivaent of the dataset relation object ?
What are the new features in sql server 2016?
What are wait types?
What do you mean by data manipulation language?
define and explain the differences between clustered and non-clustered indexes.
Define Joins?
What is always encrypted?
What is the difference between TRUNCATE and DROP?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is subreport?
Explain unique key in sql server?
What are the two authentication modes in sql server?
