Force index?

Hello,

Is there a way to FORCE the use of index in the SELECT query? We have several indexes defined on tables, used in a query. One index would benefit one type of query, while other benefits the other. It seems during EXPLAIN PLAN, that it is not using the index it should.

Is there something like:
SELECT x, y, z
FROM a, b, c
WHERE a.x = b.y

   AND b.z = c.m
FORCE INDEX ind_a
?

Thank you in advance.

Alex Vilner Received on Wed May 13 1998 - 09:13:17 CDT