On Wed, Jun 30, 2010 at 12:13 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > None of your indexes are much use for this SELECT command. Imagine trying > to do the SELECT command yourself and you'll quickly see that whichever of > the supplied indexes you use you're left trying to sort a great deal of > records by hand. A good index would be > > name2, year, id > > That's all three columns in the same index, not three separate indexes one > on each column. > > Simon. >
I did the test and EXPLAIN QUERY PLAN tells its going to use still the id index and not the new created one and still its too slow. J.Rios _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
