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: SQL SELECT question

Re: SQL SELECT question

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/02/06
Message-ID: <6bgf65$ftp$1@pebble.ml.org>#1/1

In article <01bd3329$e899a120$8a0873c6_at_RATBERT.nl.stratus.com>, J. Cone <the_cone_at_g8labs.com> wrote:
>My experience in Oracle 6 is that it made a significant difference,
>because the last table was a full table scan or range scan and
>everything after that was a set of exact index lookups.
>It's probably still like that in Oracle 7 with the rule based optimizer.

I seem to recall some of the rules reversed going from 6 to 7, but it's been a loooong time... maybe it was 5 to 6... :)

>
>TurkBear <johng_at_mm.com> wrote in article
><34d757f7.84688916_at_news2.mm.com>...
>> My understanding is that Oracle reads from last to first in the where
>> clause -- however the optimizer my change that... I usually place the
>> most restrictive where clause ( that is the one that reduces the
>> potential eligible rows the most) as the last where statement, but I
>> am not sure that this actually improves things to any measurable
>> degree.
>>
>> Just my opinion
>>
>> John Greco
>> Oracle DBA
>>
>>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!
Received on Fri Feb 06 1998 - 00:00:00 CST

Original text of this message

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