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

Home -> Community -> Usenet -> c.d.o.misc -> Re: 3 table query question

Re: 3 table query question

From: <e_humblot_at_wanadoo.fr>
Date: Tue, 23 Jun 1998 23:06:35 +0200
Message-ID: <6mp60q$e3i$1@platane.wanadoo.fr>


Try putting the smallest table in the last position of the FROM clause : the optimizer will access this table first hence issuing a full table scan on it (instead of a larger table) Received on Tue Jun 23 1998 - 16:06:35 CDT

Original text of this message

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