Re: indexing SET columns
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.
Subject
Views
Written By
Posted
3079
December 11, 2004 01:12PM
Re: indexing SET columns
1884
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.