Post reply

How can I force a select statement NOT to use a specific index ?

  • October 2, 2019 at 8:40 pm

    #3685460

    Is there a query hint or other syntax or mechanism that will force optimizer not to use a specific index?

     

    Likes to play Chess

  • October 2, 2019 at 9:07 pm

    #3685461

    Well you can force it to use a different index.  You could also disable the index.

  • October 3, 2019 at 1:04 am

    #3685523

    No hints to say anything but. As ZZMartin noted, you have a couple options.

  • October 3, 2019 at 3:03 pm

    #3685742

    It would be cool if there were a WITHOUT keyword.

    ...

    FROM <table> WITHOUT (INDEX(<index(s) you dont want to use>))
    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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