Post reply

DTA Recommendations

  • November 18, 2010 at 5:12 am

    #388257

    Hi

    I analyzed a query in DTA.

    It recommended the following indexes:

    CREATE NONCLUSTERED INDEX iX_table1_Column1 ON dbo.table1 ( Column1 ) INCLUDE ( Column2)

    CREATE NONCLUSTERED INDEX iX_table1_Column1 ON dbo.table1 ( Column1 ) INCLUDE ( Column3)

    CREATE NONCLUSTERED INDEX iX_table1_Column1 ON dbo.table1 ( Column1 ) INCLUDE ( Column4, Column5)

    Is it necessary to create all the 3 above mentioned indexes or

    CREATE NONCLUSTERED INDEX iX_table1_Column1 ON dbo.table1 ( Column1 ) INCLUDE ( Column2, Column3, Column4, Column5)

    will be sufficient.

    Kindly suggest.

    Rgds

    Mohan Kumar VS

  • November 18, 2010 at 5:27 am

    #1252416

    The index you suggest will be covering for the same queries as the other 3 indexes so should help.

    The real question whether the queries affected need help or would the detrimental affect on the system outweigh any benefits.

    I think the tuning advisor is of little real value.


    Cursors never.
    DTS - only when needed and never to control.

  • November 18, 2010 at 5:35 am

    #1252421

    Thanks Nigel.

  • November 18, 2010 at 5:59 am

    #1252434

    nigelrivett (11/18/2010)

    I think the tuning advisor is of little real value.

    Agreed. Test any recommendations carefully

    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

  • November 18, 2010 at 11:19 pm

    #1252870

    Thanks Gail.

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

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