SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

What Are Your Indexing Strategies?

A couple weeks ago, I got some pretty great new.  The book proposal that I had submitted to Apress was accepted.  Over the next few months, I’ll be working on a book with a focus on indexing.

As part of this, I want to find out your indexing strategies?  It’s not that I don’t have a list already, some of the items I plan to cover are:

  • Clustering choices
  • Covering indexes
  • Including columns
  • Indexing foreign keys

These are just a few of the strategies for indexing, but there are more.  So I’d like to know your strategies.  Knowing I don’t know everything, what do you do that you would want to see mentioned?

Related posts:

  1. An Index on Indexing #TSQL2sDay
  2. Index Those Foreign Keys
  3. Presenting on Indexing at PASS Summit 2009


Posted by John Sansom on 22 March 2011

What about Indexing based on workload type, for example OLTP vs Reporting.

Posted by John Sansom on 22 March 2011

Another interesting angle, what considerations should you give to your Indexing Strategy for Replicated databases? Think performance penalty for writes at Subscribers.

Posted by Jason Brimhall on 22 March 2011

Any room in there for Full-text indexing?

Posted by Anonymous on 23 March 2011

Pingback from  Dew Drop – March 23, 2011 | Alvin Ashcraft's Morning Dew

Posted by Jason Strate on 4 April 2011

@John - planning to try and cover both from an OLTP and DW perspective.  Hadn't thought about the replication bit.  I'll add that to the notes I am working on

@Jason - There is a chapter that is going to focus on when to look into Full-Text, Spatial, and XML indexes.  With the other items, it won't go too into depth.  It'll serve more as a guideline to what will be your trigger.

Leave a Comment

Please register or log in to leave a comment.