Re: Access and Filter Predicate on same execution plan line

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