MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizing query
Posted by: Rick James
Date: February 28, 2012 07:57PM

How many different values in `status`? If more than some precentage of the table has a particular status, the index will not be used.

Hmmmm... Arg1..31 Smells like days of the month. Shouldn't you have another table with
id -- for joining with your table
TINYINT UNSIGNED -- value 1..31
varchar(100)

Options: ReplyQuote


Subject
Views
Written By
Posted
1846
February 24, 2012 06:07AM
1046
February 24, 2012 01:16PM
928
February 25, 2012 03:49AM
1235
February 27, 2012 05:57AM
1016
February 25, 2012 05:54PM
914
February 27, 2012 06:04AM
Re: Optimizing query
999
February 28, 2012 07:57PM


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.