Re: Access and Filter Predicate on same execution plan line

What operation (or set of operations) are you calling an "index merge"?

Regards
Jonathan Lewis

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

> Well, the reason for that was to avoid index merge, which was rather
> expensive at that time. People were trying to kill two birds with one
> stone or solve two problems with a single index. I am not sure when did
> index merge get cheaper, I think it was in version 7, but I may be
> wrong. For the record, I don't kill birds. I let my cat do that. I named
> my cat "Tiger", after Bruce Scott's cat and he lives up to the name.
>
> Regards
>
> On 8/18/21 7:46 AM, Jonathan Lewis wrote:
> >
> > 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
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l