I'm using Cache SQL and want the ability to choose a specific index.
I've boiled the problem down to one table and simplified the query down to
SchedApptNum is indexed, but instead of using that column, "Show Plan" indicates that it's looping through the entire Registration.PatResp table on Id (the primary key for the table).
I've done a tune-table with no change.
SQL provides %IGNOREINDEX, which allows me to ignore a specific index, but I don't need that. I need the reverse - %CHOOSEINDEX so that I can force SQL to use a specific index.