Post reply

I need to create an index to stop a lookup

  • October 13, 2009 at 12:50 pm

    #216265

    I have look up which is due to col 1,2,3,4 in the select list.

    There is already a nonclusterd index on col 1 and is 900 varchar, so i need to use included col in ordwer to make the index work other wise it is to big.

    If I drop that index and create a new one on col 1 using include on col on 2,3,4 will it the index be use it?

    None of these col are being used in the where clause.

    THANKS

  • October 14, 2009 at 1:05 am

    #1065511

    Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

  • October 14, 2009 at 7:19 am

    #1065635

    Thanks got to work,

    there was no clustered index on the table.....soon as I added that they col were grabbed by clustered index seek.

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

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