Post reply

How to set manual index priority in a select query

  • June 13, 2012 at 9:07 pm

    #262397

    I have a table which has some 3 indexes (1 clustered and 2 non clustered) . is there any possibility that i can make a particular index column to be considered first to scan. if possible kindly tell me how to do it?.

  • June 14, 2012 at 2:48 am

    #1500833

    Yes, but I recommend you don't unless you know exactly whey the optimiser is not choosing the index you want and you are absolutely and copletely sure you know better than the optimiser which indexes work for this query.

    Any chance of posting the query and the index definitions?

    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

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

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