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

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License