Partition Range Iterator means using more than one partition but not all them to complete your query, so that it will fully scan one by one.
If it use all partitions, that will be Partition Range All. If it use only one, Partition Range will not appear in EXPLAIN PLAN.




Reply With Quote