Does Firebird support table or join hints? I can't get Firebird to use the
appropriate index when returning results from a subquery even when there
exists an index on the joined column. My query is fairly complex, but even
when I break it down to the following, it won't use the index on ID2 of
table A. Table A contains tens of thousands of rows.


SELECT A.NAME
FROM A
WHERE A.ID2 IN
(SELECT B.ID2
FROM B, C
WHERE B.ID1 = C.ID1
AND C.NAME = 'FOO')

Any suggestions other than rewriting the query?


[Non-text portions of this message have been removed]