-
Each field of the proposed 15-field compound index is either boolean, small ints, or small strings.
-
All queries are guaranteed to use at least the first ~10 fields
Given these conditions, is such proposed index feasible or is it a red flag?
What other things do I need to consider?