MySQL Forums
Forum List  »  General

Advanced Search
New Topic

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

> how much raceID is needed in some of my indexes

I expect it depends on query filters and data distribution, so to find the answer to that, I'd look at Explain Extended output, and performance, with and without that column in the index (with query caching off of course).

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.