On Mon, Apr 7, 2014 at 11:51 AM, Jens Miltner <j...@mac.com> wrote: > We get an sqlite3_log() message with errorCode 284 and message "automatic > index on ...". > I assume this is some performance penalty warning, but I have no idea what > to make of it: > > We do have an explicit index on the table and column mentioned in the > warning message, so I don't know what to do to avoid this warning and > potentially improve the query performance. >
The warning is to let you know that SQLite could not find a way to use your index and so it had to make its own index, which might result in a query that is slower than you were counting on. > > Can anybody shed light on this warning message (it's issued by the code in > sqlite3.c, line 11008)? > > > Thanks, > -jens > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
