Re: Using an ENUM column in an index
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.
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.