A complete collection of Sql server Interview Questions,sql server performance,stored procedure, trigger,Sql query,security,ms sql server 2005,database backup,restore,free ebook,tutorials.
Feb 19, 2008
What are “Index statistics”?
Statistics are something the query optimizer will use to decide what type of index (table scan or index scan) to be used to search data. Statistics change according to inserts and updates on the table, nature of data on the table etc...In short “Index statistics” are not same in all situations. So DBA has to run statistics again and again after certain interval to ensure that the statistics are up-to-date with the current data.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment