ORDERED

Ordered Hint Description

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 on 

Published 21st February 2023