No, the order of terms in a WHERE clause does *not* effect index usage.
On Apr 22, 2009, at 11:36 AM, Steve Friedman wrote: > See (possibly among others) http://www.sqlite.org/cvstrac/tktview?tn=3678 > > Steve Friedman > > Joanne Pham wrote: >> Hi All, >> I was wondering if we need to have the order of columns in the >> where clause need to be matched with the order of the indexes. >> Does the index will be used if the columns in the where clause >> didn't match with the columns in the defined index? >> Thanks, >> JP >> >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
