Re: are index scans possible with bitwise comparison

[Gary Byatt]

Thanks Jay, for an excellent answer
I have two supplemental questions arising from it.

If I add 3 further conditions:
1) I fix the number of bits, I currently have 7
2) Speed is more important than space
3) There is not a 50:50 distribution in the 1 / 0 values and I know for each of the bits which will have the greater probability 1 or 0.

Q 1) Then would it be better to simply make the 7 bits separate indexed TINYINT(1) fields?
Indexing binary values seems inherently inefficient, however so does joining tables.

Q 2) Does the BIT type, mentioned very little in the 4.1 docs as available from 5.05 for InnoDB, give any advantage for the type of solution proposed in ‘Q 1’?

Thanks again for your incisive answer

Regards
Gary Byatt