Using the ORDERED Hint
ORDERED Hint
The ORDERED hint forces the optimizer to join tables in the order they appear in the FROM clause. Without this hint the optimizer will choose the order in which to join the tables. It is recommended to use the LEADING hint which is more flexible.
Example
SELECT /*+ ORDERED */ * FROM MyTab1 a, MyTab2 b, MyTab3 c WHERE a.col1=b.col1 AND b.col2 = c.col2 /
Published 21 February 2023