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
