Hi All, I have 2 individually indexed fields. I have a select statement...
select * from table1 where field1='x' and field2='y' this takes about 10 sections, yet if I do... select * from table1 where field1='x' it's instant, and if i do... select * from table1 where field2='y' it's also instant. What's going on here?! Thanks Ray -- View this message in context: http://old.nabble.com/Very-Odd...-where-field1%3D%27%27-or-field2%3D%27%27-is-slow-tp28491829p28491829.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
