On Wed, Sep 15, 2010 at 5:46 PM, Roger Binns <rog...@rogerbinns.com> wrote: > 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.
SQLite doesn't support automatic indexing, are you sure SQLite is what you're using? If you already know which columns to create an index on, run CREATE INDEX manually. -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
