Things would improve if partition elimination
took place, things would probably get a
lot worse if it didn't.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Nuno Souto wrote in message <3b8ba605.17285559_at_news>...
>abnormal. If the problem is the root index block, do you think a
>partitioned local index might help? I'm thinking: there would now be
>as many "root" blocks as there are local index partitions, with a
>consequent lightening up of the load on a single block. Does this
>make sense?
>
>
Received on Tue Aug 28 2001 - 10:42:47 CDT
