Re: Partitioning Limitations
Posted by:
Premal Shah
Date: September 22, 2009 08:28AM
Thats interesting. Assuming I can redo the table definition to enable partitions, I have a few questions.
1) Can one have slightly different indexes on the different partitions?
2) Will it be slower to execute a query which will load data from different partitions and combine them together as opposed to loading data from a single table without partitions?
3) Is MySQL working on adding the Global Index concept to overcome this limitation?
4) Will mysql allow auto incrementing columns in the future which are not forced to be a part of the Primary Key?
Subject
Views
Written By
Posted
6276
September 17, 2009 07:50PM
2748
September 18, 2009 11:11PM
2545
September 21, 2009 02:59AM
Re: Partitioning Limitations
2693
September 22, 2009 08:28AM
2532
September 27, 2009 10:27PM
2583
September 27, 2009 10:47PM
2747
October 03, 2009 02:43AM
2751
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.