MySQL Forums
Forum List  »  General

Re: Using an ENUM column in an index
Posted by: Peter Brawley
Date: March 16, 2015 10:50AM

It's hard to imagine a situation where indexing an Enum column would be worthwhile. If there are very few rows, the index makes no significant difference. If the index is large, there must be very many instances of each Enum value, so index cardinality is very low, so the index is useless.

Options: ReplyQuote


Subject
Written By
Posted
Re: Using an ENUM column in an index
March 16, 2015 10:50AM


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.