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
    
It does not make much sense defining an index to a VERY low cardinality column as in your example - just three possible values. Indexes serve to narrow queriable data. But, I bet your queries rely on other columns, don't they? Can you enrich your problem, with the actual schema and query samples? –  mvaraujo Apr 20 at 5:26

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.