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
- 9119 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
Do you know what are the reporting services components?
How to fetch the next row from a cursor with a "fetch" statement?
How to declare and use cursor variables?
What is temporal data type?
What is RAID? What are the different types of RAID configurations?
What is explicit mode in sql server?
What are different types of raid levels?
What is explicit cursors?
What are the differences between left join and inner join in sql server?
Can we call future method from queueable?
Explain the difference between functions and stored procedures in sql server?
What is the difference between Normalization and De-normalization?
How many categories of data types used by sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are different types of roles provided by ssrs?
