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: oracle 8.1.7 SQL tuning

Re: oracle 8.1.7 SQL tuning

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Mon, 01 Oct 2001 15:19:14 +0400
Message-ID: <3BB85132.503DF1B6@bill.mts.ru>


Jon wrote:
>
> I have (mistakenly) been reading the documentation and it seems to imply
> that the order at which you specify the joins affects the performance
> because it specifies to Oracle which table is to used as the driving table
> for the join. Can anyone please correct me or add details to this seemingly
> surprising feature. Thanks in advance.

Oracle8i. Designing and Tuning for Performance. Release 2 (8.1.6).

          December 1999. Part No. A76992-01    7. Using Optimizer Hints

      Using Hints
         Hints for Join Orders

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia
Received on Mon Oct 01 2001 - 06:19:14 CDT

Original text of this message

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