MySQL Forums
Forum List  »  Performance

Re: indexing SET columns
Posted by: Peter Zaitsev
Date: December 15, 2004 01:51PM

Set column is tricky. It is actually bit map internally with bits corresponding to
row having this value in the set or not.

BTREE indexes can typically help optimizing = and </> operations. It is not easy to generally optimize finding some bits set.

So in your case it is expected MySQL picked up the key without SET column in it.

Options: ReplyQuote

Written By
December 11, 2004 01:12PM
Re: indexing SET columns
December 15, 2004 01:51PM

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.