You are searching on city and state, general the number of records per city is small (high cardinality) while per states it is larger (lower cardinality).
As there are more distinct values (i.e. high cardinality) for city, it is better to create an index on (city, state) than (state,city).
No comments:
Post a Comment