Indexing Strategies

  • Jason Strate
  • Grant Fritchey

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 nonclustered 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

Index Intersection Execution Plan Index Pattern Temporary Object Temporary Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-1118-2_11_MOESM1_ESM.zip (27 kb)
Performance Indexing - Chapter 11 - Index Strategies.zip (zip 27 kb)

Copyright information

© Jason Strate and Grant Fritchey 2015

Authors and Affiliations

  • Jason Strate
    • 1
  • Grant Fritchey
    • 1
  1. 1.MNUS

Personalised recommendations