I tried optimize. sqlite> pragma main.optimize; Error: database schema has changed
sqlite> pragma temp.optimize; sqlite> Anyone know what the error message means? On Mon, Apr 3, 2017 at 11:42 AM, jose isaias cabrera <jic...@barrioinvi.net> wrote: > > Thanks, Dr. Hipp for the new release of SQLite v3.18.0. One of bullets of > the new Added the PRAGMA optimize command is, > > (Not yet implemented) Create indexes that might have been helpful to recent > queries. > > May I also suggest that the tool also provides info on useless indexes. > Thanks. > > josé > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- David Burgess _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users