Re: SQL SELECT question

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.

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
>
>
Received on Fri Feb 06 1998 - 00:00:00 CST