Interview Questions  

Go Back   Interview Questions > Interview Questions & Answers > Information Technology > Databases > DB Administration

DB Administration DB Administration Interview Questions, Learn by sharing DB Administration Interview Questions asked in various Companies, Get Career advices, Interview Procedures from DB Administration experts, Post asked DB Administration Interview Questions and Answers.

   

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-16-2008, 06:44 AM
Senior Member
 
Join Date: Mar 2008
Posts: 4,634
Default What are statistics, under what circumstances

What are statistics, under what circumstances they go out of date, how do you update
them?

Reply With Quote
  #2 (permalink)  
Old 07-07-2008, 12:56 PM
Junior Member
 
Join Date: Jul 2008
Posts: 5
Default

Statistics determine the selectivity of the indexes. If an indexed column has unique values then the selectivity of that index is more, as opposed to an index with non-unique values. Query optimizer uses these indexes in determining whether to choose an index or not while executing a query.

Some situations under which you should update statistics:
1) If there is significant change in the key values in the index
2) If a large amount of data in an indexed column has been added, changed, or removed (that is, if the distribution of key values has changed), or the table has been truncated using the TRUNCATE TABLE statement and then repopulated
3) Database is upgraded from a previous version
Reply With Quote
Reply

Tags
db administration, interview questions

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On