MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Index in partition table?
Posted by: Mattias Jonsson
Date: December 11, 2008 08:52AM

No, it does not create any implicit index for `id` (the partitioning will only use the `id` column for calculating which partition to use, it does not use indexes).

So you need to create the index explicitly if you want it `id` indexed.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Index in partition table?
4754
Ashok kumar
November 12, 2008 06:17AM
Re: Index in partition table?
3079
Mattias Jonsson
December 11, 2008 08:52AM


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.