Index Exam

Download PDF

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 *


SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

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

Stedman Solutions