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=""> <s> <strike> <strong>

Powered by sweet Captcha

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: