Index Exam

Test…test.  this is only a test.

Each questions is worth between 0 and 10 points, with the correct answer being worth 10, the worst answer being worth 0, and questions that are partially right, or not horrible are somewhere between 0 and 10.

This is an evaluation to determine if you have the right information to be creating create indexes. With indexes a little information can be more dangerous than not knowing about indexes.

Does adding an index always improve performance?

 
 

How many columns is too many in an index?

 
 
 
 

If 2 indexes are added to a table with the exact same columns in the same order, what does it do to performance?

 
 
 
 

What is the best data type to use for a clustered index?

Best implies best for overall system performance, maintenance, sustainability.

 
 
 
 


Question 1 of 4


 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweetCaptcha