I am getting the same thing with just plain,
PRAGMA optimize;
-----Original Message-----
From: David Burgess
Sent: Sunday, April 2, 2017 9:56 PM
To: SQLite mailing list
Subject: Re: [sqlite] SQLite Release 3.18.0
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
<[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
David Burgess
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
