subject:"\[sqlite\] Should I do analyze\?"

Re: [sqlite] Should I do analyze?

2013-06-26 Thread Roger Binns

-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

[sqlite] Should I do analyze?

2013-06-25 Thread Navaneeth.K.N

Hello, I learned about the use of ANALYZE command recently. In my application, SQLIte file is generated once and never modified. Currently my application creates SQLIte database, creates required tables, indexes and inserts records into it. As a last step, it runs VACUUM. I am wondering should I