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
- 8999 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
whats new about truncate in sql server 2008?
Where are SQL server users names and passwords are stored in sql server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Can you pass expressions to function parameters?
Explain about link server in sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the full form of dql?
What is PROJECTION Operation?
Which are the new data types introduced in sql server 2008?
can you instantiate a com object by using t-sql? : Sql server database administration
How to delete existing rows in a table?
What is a trace frag?
What is row-level compre?
Name few of the dcl commands in sql?
what is the system function to get current user's user id? : Sql server database administration
