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.

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.

 
 
 
 


 

Leave a Reply

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

*


nine − 8 =

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>