On Tue, Aug 27, 2013 at 10:49 AM, Doug Nebeker <[email protected]> wrote:

> Does the order of columns in a WHERE clause matter, or will the query
> optimizer look at them as a set and find the best index?
>


WHERE clause order does not matter.  The optimizer looks at the terms of
the WHERE clause as a set.

-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to