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
- 8885 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
Can I disable or restrict ssrs export formats (rendering formats)?
How do I start and stop sql server?
How to rename an existing column with sql server management studio?
Explain security with sql azure?
How will you decide the active and passive nodes?
Why SQL Agent is used?
what is a check constraint?
What are the differences between char and varchar in ms sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Explain the disadvantages/limitation of the cursor?
What is the difference between inner join and equi join?
where the connection string store in the database
what data regions are and what are the different data regions?
Define cursor locking
What is a data source file?
