MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Using an ENUM column in an index
Posted by: Rick James
Date: March 17, 2015 10:16PM

An ENUM is stored as a 1-byte or 2-byte number. (1 byte for up to 256 values.) So your 255-element ENUM will take only one more byte in the index if it is NOT NULL.

You may as well make ENUMs "NOT NULL".

Let's see some of your indexes and the SELECTs that 'need' them.

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


Subject
Written By
Posted
Using an ENUM column in an index
Tom Byars
March 16, 2015 09:18AM
Re: Using an ENUM column in an index
Tom Byars
March 16, 2015 09:48AM
Re: Using an ENUM column in an index
Peter Brawley
March 16, 2015 10:50AM
Re: Using an ENUM column in an index
Tom Byars
March 17, 2015 07:49AM
Re: Using an ENUM column in an index
Peter Brawley
March 17, 2015 10:39AM
Re: Using an ENUM column in an index
Rick James
March 17, 2015 10:16PM
Re: Using an ENUM column in an index
Tom Byars
March 18, 2015 01:58AM
Re: Using an ENUM column in an index
Tom Byars
March 18, 2015 05:53AM
Re: Using an ENUM column in an index
Peter Brawley
March 18, 2015 10:08AM
Re: Using an ENUM column in an index
Rick James
March 18, 2015 06:12PM
Re: Using an ENUM column in an index
Tom Byars
March 19, 2015 05:15AM
Re: Using an ENUM column in an index
Peter Brawley
March 19, 2015 11:16AM
Re: Using an ENUM column in an index
Rick James
March 19, 2015 11:39PM
Re: Using an ENUM column in an index
Tom Byars
March 20, 2015 02:24AM
Re: Using an ENUM column in an index
Tom Byars
March 18, 2015 01:46AM


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.