query conditions like this

CodePudding user response:

Index is established on the basis of the use of,
Which field the query will be used, at least use frequency, to build the index, if it is a composite index, using high frequency field on the front,
Using the same frequency fields, difference big field, on the front,