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