On Tue, Aug 27, 2013 at 10:49 AM, Doug Nebeker <ad...@poweradmin.com> 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
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to