Force Indice
HI
How to force a specific index in SQL?
Discussion (3)2
Comments
You can try to use %IGNOREINDEX
This function does not help me.
I need something contrary to this, where I inform what index should be used
%ALLINDEX maybe. Also check alternate plans.
Can you show an example:
- your table definitions
- your query
- your plan
- how do you think plan should go?