A TO Z of Indexing

  • Hi all,

    Thank you for your kind support, co-operation and interest in forum posts.

    Can you please help me to find tutorial/articles about A to Z of Indexing in SQL Server.

    I want to know "Where to do", "When to do", "How to do" index in sql server tables.

    Please refer me best article which guide me basics to ultimate solution of Indexing.

    Thank you all.

  • Have you had a chance to look on SQL Server Central? The stairway series is quite nice - http://www.sqlservercentral.com/stairway/72399/

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • That could easily be an entire book (but one doesn't exist)

    Start with this series: http://www.sqlservercentral.com/articles/Indexing/68439/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end discussion of just indexes. You have to learn it a chapter here, a paragraph there, an article over that way...

    I wonder if a book could be made generic enough to discuss the indexing mechanics of what I see as the big three relationals right now (MSSQL, MySQL, and Oracle) to be worth distribution. I know I could only get involved in the MSSQL portions, I barely understand those enough to dare as it is. I couldn't touch the mechanical side of Oracle or MySQL, I don't think, other then conceptually.

    IE: I know Oracle used to use physical disk location as its RID, but I don't know if that's true anymore nor do I know enough about the rest.

    Sorry, my ramblings got distracting there...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Thank you friends, Both Articles are good enough to understand Indexes....

  • Craig Farrell (7/6/2011)


    You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end discussion of just indexes.

    Yet.

    I wonder if a book could be made generic enough to discuss the indexing mechanics of what I see as the big three relationals right now (MSSQL, MySQL, and Oracle) to be worth distribution. I know I could only get involved in the MSSQL portions, I barely understand those enough to dare as it is. I couldn't touch the mechanical side of Oracle or MySQL, I don't think, other then conceptually.

    For that you'd need someone who was extremely familiar with the architecture, internals and optimiser of all three. I think that will be hard. Comprehensive book on just one of them, very possible.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply