MySQL Forums
Forum List  »  Partitioning

Re: partition full scan
Posted by: Mattias Jonsson
Date: December 14, 2010 04:58AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2848
December 13, 2010 06:55AM
Re: partition full scan
1754
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.