No. It only collects/updates stats when you explicitly call the ANALYZE. On Sat, Aug 15, 2009 at 2:48 AM, Jim Showalter <j...@jimandlisa.com> wrote:
> It doesn't collect those statistics automatically, as part of query > plan optimization? > > ----- Original Message ----- > From: "Dan Kennedy" <danielk1...@gmail.com> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Friday, August 14, 2009 11:37 PM > Subject: Re: [sqlite] Multiple indexes in SQLite, and selecting which > to use > > > > > > On Aug 15, 2009, at 1:34 PM, Jim Showalter wrote: > > > >> How will that help him fix this problem, if the problem is that > >> SQLite's query optimizer is selecting a suboptimal index to use, > >> and > >> there is no way to specify which index to use? > > > > The statistics collected by the ANALYZE command will be used by > > SQLite to (hopefully) select the optimal index. > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users