Choosing a partition type
I have a table of 100 millions of records. The table detail is as follows
CREATE TABLE `X` (
`memberid` int(10) unsigned NOT NULL,
`exerciseid` int(10) unsigned NOT NULL,
`score` int(10) unsigned NOT NULL,
`attempted_time` datetime NOT NULL,
KEY `member_id` (`member_id`),
KEY `exercise_id` (`exercise_id`),
KEY `attempted_time_id` (`attempted_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
The table does not have any UNIQUE or PRIMARY KEY and I want to partition this table from the available partition types.
What could be best way for this type of table? Please help!
Subject
Views
Written By
Posted
Choosing a partition type
3534
March 22, 2007 10:48AM
2347
March 22, 2007 08:44PM
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.