MySQL Forums
Forum List  »  Partitioning

Re: Partition Pruning
Posted by: Mattias Jonsson
Date: September 28, 2010 10:59AM

Hi Rick, thank you for all your answers here!

When the partitioning function returns NULL (as of TO_DAYS('2010-02-31')) it will put the row in the first partition (since partitioning compares NULL to be less than any number).

Also see my reply in the other thread.

Regarding LOCAL, I guess that it opposite to GLOBAL INDEX, which MySQL does not yet have. (Global indexes would allow to break the have an unique index over columns not included in the partitioning function. It would also allow to partition the indexes separately from the data).

Options: ReplyQuote

Written By
September 17, 2010 07:18AM
September 17, 2010 07:23AM
September 18, 2010 04:13PM
Re: Partition Pruning
September 28, 2010 10:59AM

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.