Re: Partition pruning - how much optimization is smart?
You can use 'EXPLAIN PARTITIONS' before your SELECT query and see the resulting column 'partitions' to see which partitions are left after pruning.
The code that handles the pruning is prune_partitions() in sql/opt_range.cc.
Subject
Views
Written By
Posted
3438
May 09, 2010 04:21AM
Re: Partition pruning - how much optimization is smart?
1492
May 09, 2010 01:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.