Re: Partitioning Limitations
Posted by:
Rick James
Date: September 27, 2009 10:47PM
"2. Actually, because of partition pruning (see MySQL Manual), queries on partitioned tables can be significantly faster than the same queries run on their non-partitioned counterparts. :)" -- I'll dispute that.
Does anyone have a good example of that?
It's all about the number of "rows examined". If you have a good index, it will hit the same number of rows whether the table is partitioned or not. Hence, it will take the same amount of time.
Subject
Views
Written By
Posted
6285
September 17, 2009 07:50PM
2753
September 18, 2009 11:11PM
2547
September 21, 2009 02:59AM
2697
September 22, 2009 08:28AM
2536
September 27, 2009 10:27PM
Re: Partitioning Limitations
2584
September 27, 2009 10:47PM
2751
October 03, 2009 02:43AM
2756
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.