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?
Tell me more
×
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.
|
|
|||
|
|
