sql - Order of ANDS in Where clause for greatest performance -

My thinking is that if I put my ANDs which before that filters in large amounts of rows, The query should be run faster because the set of statements is very small between statements and statements

But in the WHERE section of the SQL statement and the order of the order actually affects the performance of SQL or the engine is already optimized Are you

It really depends on the adapter.

This should not be not because it is the job of optimizing the optimal method to run your query, even then how do you describe it Are there.

In practice, no adapter is correct, so you may find that re-ordering the section makes a difference to special questions. The only way to know for sure is to test yourself with your own schema, data, etc.