-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 25/06/13 22:46, Navaneeth.K.N wrote: > I am wondering should I do ANALYZE also as the last command? Will that > make the query planner happy and choose faster plans? Will that improve > the runtime performance?
Since you know what your queries and data are, why don't you benchmark it and find out? In general ANALYZE should help the query planner make better informed decisions, but those decisions can never be perfect. It is possible but not probable that some could turn out worse. The SQLite authors try to make SQLite very predictable so the query solutions chosen tend that way. An upcoming release will have a new query planner that should work better when there are a lot of joins. http://www.sqlite.org/draft/queryplanner-ng.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlHKlmUACgkQmOOfHg372QQhNwCeIth6bQJMfZHFVM/FijyoY79N 82AAn1NVyCVQj7CDPt+8grjaT41ODDxM =X88q -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
