MySQL Forums
Forum List  »  MyISAM

Re: Partial Index
Posted by: Rick James
Date: August 30, 2008 11:13AM

INDEX (foo(10))
is supported, but is almost useless for any practical purpose.

UNIQUE (foo(10))
Is a constraint on the first 10 chars of foo. This is either (1) not what you want, or (2) a poor way to design the foo column.

INDEX (big_col1, big_col2, big_col3(10))
is a trick to avoid the size limitation on indexes. But then I have questions about the schema design.

Options: ReplyQuote


Subject
Views
Written By
Posted
6908
May 13, 2008 05:46AM
3678
May 18, 2008 11:34PM
Re: Partial Index
3060
August 30, 2008 11:13AM


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.