How to use ORDERED Hint to Tune a SQL with subquery for Oracle? - Weddo

v32457_p

Member
Oct 25, 2021
151
0
16
How to use ORDERED Hint to Tune a SQL with subquery for Oracle?

Here the following is the description of the ORDERED hint.

The ORDERED hint causes Oracle to join tables in the order in which they appear in the FROM clause.

If you omit the ORDERED hint from a SQL statement performing a join, then the optimizer chooses the order in which to join the tables. You might want to use the ORDERED hint to specify a join order if you know something about the number of rows selected from each table that the optimizer does not. Such information lets you...


How to use ORDERED Hint to Tune a SQL with subquery for Oracle?