Re: partition full scan
The reason sk1 is not pruned is because you have a range in the WHERE clause. Only LIST/RANGE partitioned tables can prune on larger ranges, and it must use a function that supports range pruning, such as YEAR() or TO_DAYS(). Or use the RANGE COLUMNS partitioning directly with the date column in 5.5.
The reason st5 is not pruned is because SPELL_key_id is not specified at all.
Also partitioning pruning does only affect the query plan by reducing the number of rows to scan.
You will probably get the same query plan for non-partitioned tables.
Regards
Mattias
Subject
Views
Written By
Posted
3078
December 13, 2010 06:55AM
Re: partition full scan
1853
December 14, 2010 04:58AM
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.