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

oracle 8.1.7 SQL tuning

From: Jon <jonathan.harvey_at_cerillion.com>
Date: Mon, 1 Oct 2001 12:16:16 +0100
Message-ID: <1001934612.4575.0.nnrp-07.c3adc012@news.demon.co.uk> 





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.
Received on Mon Oct 01 2001 - 06:16:16 CDT












Original text of this message













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