Effective Clustered Indexing

My first Simple-Talk article was published yesterday! I’m pretty excited about it and wanted to share the link. In the article, I give an overview of how clustered and nonclustered indexes work, and I demonstrate why clustered index best practices — narrow, unique, static, and ever-increasing — are important design considerations.

You can find the article on Simple-Talk’s website at:

Please let me know your thoughts! 🙂

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Tagged , , , , , , . Bookmark the permalink.

8 Responses to Effective Clustered Indexing

  1. Pingback: Tweets that mention Effective Clustered Indexing « SQL Fool -- Topsy.com

  2. Rob Kraft says:

    This is a good, long, thorough article. An excellent post!

  3. Siddu says:

    Happy new year

  4. Bender says:

    Excellent article. I thoroughly enjoyed it.

  5. Bryant says:

    I’ve spent a lot of time tuning SQL and learning what I can do (and get away with) regarding indexing. you description is better than many I’ve seen. through but clear.

    One caution I would make. In your table display on page 2 you show the SalesOrderID increasing in order on a page. According to Microsoft SQL Server 2008 Internals, when a clustered index is applied, pages are sorted but entries on a page are not. They don’t need to be because the entire page is read so any access within the page is at memory speed. It doesn’t not affect the correctness of your article but is one of those misconceptions that often occur.

  6. Jeff says:

    Nice job!

  7. Thom Copenhaver says:

    Good article. I especially appreciated the discussion of “Ever Increasing”. I’m currently fighting an issue where the ever-increasing component is the third of six columns in the index. I think I understand why our performance stinks.

  8. shown says:

    Hi Michelle,

    I was so excited and eager to read about the internals of Indexes which was troubling me for a very long time. The article was so neat, simple and well written. Thanks for helping me clarify on such an important topic.

Leave a Reply

Your email address will not be published. Required fields are marked *