MySQL Forums
Forum List  »  Partitioning

Re: Partitioning Limitations
Posted by: Jonathan Stephens
Date: October 03, 2009 02:43AM

Rick, partition pruning avoids scanning rows in partitions that don't match the search criteria, so your assertion that a query examines the same number of rows whether or not the table is partitioned is incorrect.

There are several examples given in the cited section of the Manual; try running a few of them and see the results for yourself. There's another example or two given towards the end of this MySQL DevZone article, as well.

Note also that I said (emphasis added), "queries on partitioned tables can be significantly faster"; simply partitioning a table is no guarantee that queries will run faster, any more than simply indexing every column in all of your tables is going to make your queries automatically run faster. Like indexes, partitioning has to be understood and used properly to see the benefits, and misuse is likely to lead to suboptimal results.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
6267
September 17, 2009 07:50PM
2741
September 18, 2009 11:11PM
2541
September 21, 2009 02:59AM
2689
September 22, 2009 08:28AM
2527
September 27, 2009 10:27PM
2578
September 27, 2009 10:47PM
Re: Partitioning Limitations
2740
October 03, 2009 02:43AM
2746
October 03, 2009 06:03PM


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.