What are statistics, under what circumstances they go out
of date, how do you update them?
Answer Posted / koti
Statistics determine the selectivity of the indexes. If an
indexed column has unique values then the selectivity of
that index is more . Query optimizer uses these statistics
in determining whether to choose an index or not while
executing a query.
To update statistics there is command :
update_statistics
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to check table values in sql server?
What are click through reports?
Why use cursor in sql server?
What is clustered index
What are different types of raid levels?
Explain the collation?
What is the concept of optimization?
What are distinctive joins find as a part of sql?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Tell me what do you understand by a view? What does the with check option clause for a view do?
How to make conditional sum in ssrs?
Distinguish between commit and rollback?
last function used in MS Access to convert sql what function will use in sql
What is use of dbcc commands?