For compound indexes, this rule of thumb is helpful in deciding the order of fields in the index: First, add those fields against which Equality queries are run. The next fields to be indexed should reflect the Sort order of the query. The last fields re.