SQL Server Performance

Usage of indexes

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by suleman_3014, Oct 14, 2008.

  1. suleman_3014 New Member

    Hi ,
    One of my developer asked me the below questions:
    Should there be index on a case statements columns?
    Should there be index on having clause columns?
    if they are also aggregate?
    Any performance benefit?
    ... Can somebody help me with this.
    Thanks
    Suleman
    suleman_3014, Oct 14, 2008
    #2

  2. MohammedU New Member

    Welcome to the forum...
    Search for SQL server covering indexes for details...
    MohammedU, Oct 14, 2008
    #3

  3. FrankKalis Moderator

    To add to Mohammed,just go ahead and try adding indices in various combinations to see if you can benefit for them. You would also want to observe if the trade-off between data-retrieval (faster) and data-modification (slower) is acceptable for every index added.
    FrankKalis, Oct 15, 2008
    #4

Share This Page