MySQL Forums
Forum List  »  Optimizer & Parser

Re: is HASH index being ignored
Posted by: Michal Carson
Date: March 08, 2006 10:59AM

Hi Felix,

So it appears. After further reading (including http://bugs.mysql.com/bug.php?id=7936) and thinking about what a hash is doing, it seems a hash index is just not suitable to the BETWEEN style of query. It can find a direct hit, but it's not good for finding "the next one greater than." Can anyone confirm?

I've also realized that I didn't try a hash index on a MyISAM table to see if it is ignored. At the moment, I expect it would be.

Michal

Options: ReplyQuote


Subject
Views
Written By
Posted
3759
March 07, 2006 10:17PM
2092
March 08, 2006 04:32AM
1931
March 08, 2006 07:50PM
Re: is HASH index being ignored
2086
March 08, 2006 10:59AM


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.