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@xxxxxxxxx> 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:
ignorance.
It' s not an unwritten rule, it's a frequently written piece of
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