Such things as table size, number of distinct values in a column, data distribution (if histograms exist) and *many* other variables to determine the most efficient execution plan for any given statement at any given time. *VERY* far down the list of variables is the order of items in the WHERE clause; SOOO far down that in 99.9% of the cases, the order is *completely* irrelevant.