[RESOLVED] Where clause order

[Derokorian]

Just a quick question because I can't seem to find the answer I'm looking for.

Does the order of WHERE clause affect the speed of a query? IE if I want all records posted in december of 2011 that are active would it matter which I put first?

SELECT column FROM table WHERE date >= '2011-12-01' AND active=1
vs.
SELECT column FROM table WHERE active=1 AND date >= '2011-12-01'

They will fetch the same rows, however in my mind it seems like order would matter because WHERE date >= will gives me ~45 rows and then it will look thru those results to get the active records ~30 VS WHERE active gives me ~1150 rows then search those for the proper date. OR does it not matter?

[Weedpacket]

It doesn't matter in the sense that the DBMS will try to compile a query execution plan that will apply filters in whichever order it reckons (based on indexes and other such statistics) will give the best performance.

[Derokorian]

Awesome! As always, thanks for the feedback weed =D