Re: Forcing Oracle to use an order in the from clause

From: Emrynsoft <emrynsoft_at_aol.com>
Date: 1997/04/21
Message-ID: <19970421190200.PAA03001@ladder01.news.aol.com>#1/1

.....

If you are using optimizer_mode = RULE then the sequence of the Tables is the order in which the Tables are used. (It may be the other way around!) With COST or CHOOSE I dont think you have any choice.
....

Use the ORDERED hint when using cost based to force the order of the join. Be warned that the join order with the ORDERED hint is from left to right on the FROM clause, as opposed to right to left when using rule based.

....

Abhijit Received on Mon Apr 21 1997 - 00:00:00 CDT