Re: index is not used why?
Posted by:
Rick James
Date: March 24, 2009 08:11PM
* ROW_FORMAT=FIXED is much overrated. If your rows vary in width even a little, you save disk space by letting it be DYNAMIC. This leads to better caching which leads to being faster.
* Yeah, in a few selected cases, multiple indexes will be used. But it is not all cases.
* The selects weren't faster? Did you add the index I recommended:
KEY (n_group_id)
and make this change
KEY (`n_resource_id`,`n_group_id`, c_id) -- field added
??
* "Why does MySQL think to scan all rows instead using the key?" There are lots of reasons. Here is one:
http://forums.mysql.com/read.php?21,253989,254168
Subject
Written By
Posted
Re: index is not used why?
March 24, 2009 08:11PM
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.