What's the query timing difference if the indexes aren't defined as
parallel?
I haven't noticed much of a difference in timings on queries not using the
partition key with non-parallel local bitmap indices . More of a problem in
the loading. But since the load is given the priority the indexes are
remaining parallel. I've made the argument that the load might be slower
with non-parallel indexes but overall throughput would be higher. The way
the load is done I can't use partition exchange, involves multiple deletes
and inserts.
-- //www.freelists.org/webpage/oracle-l