On Thu, Apr 28, 2016 at 5:28 PM, Rowan Worth <rowanw at dugeo.com> wrote:
> In an attempt to understand a slow query I've had a quick look at the > contents of the sqlite_stat1 table. It looks like the stat column contains > a series of integers like: > > <number of rows in index> > <number of rows divided by distinct values of first indexed column> > <number of rows divided by distinct values of second indexed column> > ... > > Is this observation correct? And if so, does sqlite essentially assume that > the rows are equally distributed amongst all distinct values of the column? > More or less I think, yes. --DD http://stackoverflow.com/questions/2456215/explanation-of-sqlite-stat1-table
