Everyone in writing SQL statements, especially the condition judgment, how to guarantee higher index of use?

CodePudding user response:

Ensure the index effectively, remember that index failure
the condition of the1. The condition judgment exists in the fields related expression, index of failure
2. The Like, can make the index lost effect in
3. When using the composite index, and combination query conditions to the order of the index is consistent, or index will failure