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
- 9011 Views
- HCL, I also Faced
- E-Mail Answers
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 is normalization? Explain different levels of normalization? : Sql server database administration
What is difference between count (*) and count 1?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is 2nf example?
Do you know what are pages and extents? : SQL Server Architecture
What do you understand by mirroring?
What is the maximum rows in sql server table?
How can we rewrite sub-queries into simple select statements or with joins?
What is a mutating table error and how can you get around it?
Explain the difference between functions and stored procedures in sql server?
What does the update command do?
What is optimization and its types?
How to test odbc dsn connection settings?
How to remove duplicate rows from table except one?
explain how to create a new schema in a database? : Sql server database administration
