On 7 Feb 2011, at 9:37pm, Sven L wrote: > Thanks for input. So you're saying that creating the tables manually is not > the same as issuing the "ANALYZE" command?
You have no idea what the ANALYZE command does because it's not documented. For all you know different versions of SQLite put different things in this table. So don't try to simulate it, let SQLite do it. It's hardly difficult: just issue that one instruction. As I wrote upthread, you might want to do it about as often as you'd run the integrity check routine. By the way you may be overestimating the impact of doing this. It will matter only in situations where the query optimizer will never have to guess how best to do its searches. If you've created good indexes and specified your WHERE and ORDER BY clauses well, use of this table will be very low. There is definitely little point in doing this until the particular installation has lots of data in its tables ... perhaps after months of having had data entered. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
