-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've got a large third party data set I imported into SQLite. Queries are surprising fast especially since I haven't created any indices yet. The reason turned out to be because of the automatic index functionality.
When doing an "explain query plan", the text comes out like this: TABLE toys WITH AUTOMATIC INDEX Would it be possible to add more detail to that such as which columns the index is on? eg TABLE amw_track WITH AUTOMATIC INDEX on (weight, colour) This would make it a lot easier to manually or automagically create indices if I know my queries in advance. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkyRaPsACgkQmOOfHg372QT6cQCg5PBdg1O729p1XEcOnqViGibw mCQAoIiPY9iZrXgLNsomyVVRy+Dgx+U0 =BcNd -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
