Is a 15-field compound index feasible or a red flag?

  1. Each field of the proposed 15-field compound index is either boolean, small ints, or small strings.

  2. 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?