MySQL Forums
Forum List  »  General

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

That's index selectivity = 0.0001, operationally indistinguishable from zero. MySQL tends to ignore indexes with selectivity < 0.3. Before putting such an index into production, I'd want to prove that it actually makes a positive performance diff.

Options: ReplyQuote


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


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.