-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/07/2010 04:55 PM, Raeldor wrote: > That's interesting, I'll give that a shot. I've noticed in my dealings with > MS Sql server, that it is very bad at using compound indexes... I hope > sqlite is better! :)
Put "explain query plan" in front of your query and you'll see exactly what happens. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkvkuXUACgkQmOOfHg372QSujgCcC/qtk7l5ZcPMhlBoMEOoXUjM p4MAoMcqie7aMDge6GOIf+Kd+a6ujk5m =K69A -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
