MySQL Forums
Forum List  »  Partitioning

Partition Pruning Documentation
Posted by: Jonathan Stephens
Date: February 24, 2006 07:11PM

Hi!

As you may have heard, MySQL 5.1.6 adds the ability to "prune" partitions, making many queries much faster than before (and faster than the same queries against tables with the same structure and data that aren't partitioned).

I've just added some info about how this is done so you can take advantage of it:

http://dev.mysql.com/doc/refman/5.1/en/partitioning-pruning.html

This is really a draft, but we're pretty excited about this enhancement so I've gone ahead and added it to the Manual anyway. Your observations and feedback are welcome in this thread, or you can send me an email (jon AT mysql DOT com) if you'd rather. Check back because I'm sure there will be some improvements made after we get some feedback.

Have a nice weekend!

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition Pruning Documentation
2962
February 24, 2006 07:11PM


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.