Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a "State" column that has a low cardinality (three possible value), on which most of my queries perform an equality selection (WHERE col = 'blah') AFAIK you need something like a bitmap index to speed this up, which is not available in MySQL. The column value changes from state1 -> state2 -> state -> 3 etc., so I couldn't use partitioning.
How could one speed things up in this situation?

share|improve this question
If you want all rows satisfying the equality condition, index is useless –  user1931858 Dec 14 '13 at 19:24
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.