This question mostly applies to SQLite4, where a number of things will be changing anyway.
How do folks feel about the ANALYZE command ? I started off thinking about wanting an 'ANALYZE OFF' command to delete the tables that ANALYZE makes up. But that just made me think that the ANALYZE command itself should really be a PRAGMA, so you could use the normal syntax of PRAGMA analyze = OFF or even query the status to see whether there were ANALYZE tables or not. What does the team think ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users