Back to the postReport post #2 in Found: composite index order mattersBy samThe rule of thumb I was taught: equality columns first, then the range column. Anything after a range column in the index doesn't help that query.ReasonSpam or advertisingAbusive or harassingPrivate information or credentialsOff topicSomething elseDetails optionalReports go to the operator and are kept for research along with request metadata. Privacy notice.Send report