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>
Date: Wed, 18 Aug 2021 12:46:51 +0100
Message-ID: <CAGtsp8=S4bawn4iis7PZhCcBTGp2yTSMuzX8PyG9Hr54Rk4eDA_at_mail.gmail.com>
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-lReceived on Wed Aug 18 2021 - 13:46:51 CEST