MySQL Forums
Forum List  »  Optimizer & Parser

Indexes and bit functions?
Posted by: Victor Svetogor
Date: March 14, 2008 03:08AM

Hi All!


Explain me please - can MySQL 5.1.x or 6.x.x use indexes with bit functions? For example: i have table with index by field "a". In MySQL 5.0.37 select statement like "select * from tbl where (a&0x10)=0;" don't use any index.

Thanx, Victor.

Options: ReplyQuote


Subject
Views
Written By
Posted
Indexes and bit functions?
3041
March 14, 2008 03:08AM


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.