Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing Oracle to use an order in the from clause

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

From: Amin Adatia <tmpaadatia_at_ptc.com>
Date: 1997/04/18
Message-ID: <3357755C.739B@ptc.com>#1/1 







Hi!



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.



Regards



amit srivastava wrote:


> 

> Can you force Oracle to use a particular table order in the

> from clause? Esp. if you have outer joins in them?

> 

> Thank you for any information.

> -amit

 

-- 
Amin Adatia
KnowTech Solutions Inc (	amin_at_istar.ca	(613)226-8378 )
at Parametric Technology Corporation  		(617)398-6332


Received on Fri Apr 18 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US