Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning When to Index RE: When to Index

  • January 7, 2013 at 1:28 pm

    #1574512

    SQLRNNR (1/7/2013)

    dwilliscp (1/7/2013)

    GSquared (1/7/2013)

    "When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

    There's no way to tell, from what you wrote, wether you should index something or not.

    Start out with a book on performance tuning. Read online articles on it, too, but pick out a good book as a first step.

    My readings are:

    A Guide for the Accidental DBA, Mastering Server Profiler, Performance Tuning DMV, SQL Server Tacklebox.

    Any suggestions?

    I'd start with these

    A Guide for the Accidental DBA

    Performance Tuning DMV

    Those are the books that I have already read, in the past year. They are helpful, but do not cover the details of when to create an index. (I believe the index script came out of the accidental DBA book.)