The following query runs quite slowly:
SELECT * FROM TAB1
INNER JOIN TAB2
ON TAB2.FIELDA = TAB1.FIELDC
WHERE TAB2.FIELDB = value
but if the order of the tables in the query is reversed, it performs better:
SELECT * FROM TAB2
INNER JOIN TAB1
ON TAB2.FIELDA = TAB1.FIELDC
WHERE TAB2.FIELDB = value
Is this a problem or the expected behavior for INNER JOIN queries?
Datacom SQL Option - all releases
INNER JOIN forces the join order and the only restriction in the above queries is on the TAB2 table, hence it runs better when TAB2 is the first table.