MySQL Forums
Forum List  »  Partitioning

Feature Request: Global Indexes for Partitioning
Posted by: fz wsc
Date: May 27, 2006 03:23AM

Now, to be a partition key, a column has to be included in PRIMARY KEY().
For instance, in the following statement, I don't really want `p1` be included in the PRIMARY KEY. Is this suggestion reasonable?

CREATE TABLE `t1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`p1` varchar(50) NOT NULL,
PRIMARY KEY (`id`,`p1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1
COLLATE utf8_general_ci
PARTITION BY LINEAR KEY(`p1`)
PARTITIONS 4;



Edited 1 time(s). Last edit at 05/29/2006 07:18PM by Edwin DeSouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
Feature Request: Global Indexes for Partitioning
2855
May 27, 2006 03:23AM
1897
May 27, 2006 01:30PM


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.