Index Strategies

  • Jason Strate
  • Ted Krueger

Abstract

Indexing databases is often thought of as an art where the database is the canvas and the indexes are the paints that come together to form a beautiful tapestry of storage and performance. A little color here, a little color there, and paintings will take shape. In much the same way, a clustered index on a table and then a few non-clustered indexes can result in screaming performance as beautiful as any masterpiece. Going a little too abstract or minimalist with your indexing might make you feel good, but the performance will let you know it isn’t too useful.

Keywords

Shipping 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jason Strate and Ted Krueger 2012

Authors and Affiliations

  • Jason Strate
  • Ted Krueger

There are no affiliations available

Personalised recommendations