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
- 9127 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
Please explain what is “asynchronous” communication in sql server service broker?
What is mean by dml?
What is the fillfactor concept in indexes?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Does sql server 2000 clustering support load balancing?
Why use sub query in sql server and list out types of sub queries?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Which tcl commands are available on the sql server?
How do I start sql server?
What is the new security features added in sql server 2014? : sql server security
Please illustrate physical database architecture? : SQL Server Architecture
What is NOT NULL Constraint in sql server 2012?
what is nonclustered index
How to stop log file growing too big?
What is difference between Datepart() and Datename() in SqlServer?
