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
6477
September 17, 2009 07:50PM
2861
September 18, 2009 11:11PM
2626
September 21, 2009 02:59AM
2768
September 22, 2009 08:28AM
2626
September 27, 2009 10:27PM
Re: Partitioning Limitations
2675
September 27, 2009 10:47PM
2852
October 03, 2009 02:43AM
2852
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.