indexing guide

  • I need to add indexes to my tables so that queries may take less time in execution. I am totally new to indexes. Can some one guide me to some good book or tutorial that explains that purpose and uses of indexes and what would be the better way of indexing any table ???

  • The documentation that comes with SQL Server (Books Online, or BOL) is an excellent resource for learning about indexes. Its contents are also available on the web. For indexes a good starting page is:

    http://msdn2.microsoft.com/en-us/library/ms191195.aspx

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • Try plaing with the Tuning Advisor that comes with SQL. Overall, it is not going to be able to give you the right answer 100% of the time. In most cases, there are 5 correct answers and sometimes the Tuning Advisor will sometimes not even guide you to one of these, but from what it produces you will be able to see a general pattern of how it is trying to solve certain issues and than can be useful.

    Also, MS has indexing best practice documents on the MSDN website. These are good to read.

  • The performance Dashboard that can be used with 2k5 SP2+ makes reading the sys.dm_missing_index views more readable.

    FYI, they are not always good choices. You have to try and see what works, and what doesn't.

    Remember the overall goal is usually to reduce the amount of data you are look for as fast as possible.

Viewing 4 posts - 1 through 3 (of 3 total)

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