It is true but it depends on the selectivity of res_level columns , does combined index increase selectivity, clustering factor.
If cardinality is low, think bitmap , u can have multiple indexes with not much space degradation and enough performace improvement




Reply With Quote