Subscribe to this blog
Briefcase
Print
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:
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.