Re: Access and Filter Predicate on same execution plan line

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Wed, 18 Aug 2021 12:46:51 +0100
Message-ID: <CAGtsp8=S4bawn4iis7PZhCcBTGp2yTSMuzX8PyG9Hr54Rk4eDA_at_mail.gmail.com>



It' s not an unwritten rule, it's a frequently written piece of ignorance. It was very close to true for Oracle version 5. But very few people stopped to rethink their optinion when Oracle 6 came out./

Regards
Jonathan Lewis

On Wed, 18 Aug 2021 at 00:44, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Unfortunately, there is also an unwritten rule about the most selective
> column coming first which is followed by most of the application
> designers and database administrators. In case of the skip scan, that
> rule will cause you to shoot yourself in a foot.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 18 2021 - 13:46:51 CEST

Original text of this message