Those fields span two tables. ~Seth
via iPhone On Aug 4, 2011, at 2:45 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 4 Aug 2011, at 8:40pm, Seth Price wrote: > >> SELECT class FROM data_r JOIN data USING (rowNum) WHERE ?1 < col0min AND >> col0max < ?2 AND ?3 < col1min AND col1max < ?4 AND ?5 < col2min AND col2max >> < ?6 AND ?7 < col3min AND col3max < ?8 AND ?9 < col4min AND col4max < ?10 >> AND ?11 < col5 AND col5 < ?12; > > Create one index on all these fields: > > (col0max,col1min,col1max,col2min,col2max,col3min,col3max,col4min,col4max,col5) > > Simon. > _______________________________________________ > 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