Richard Hipp-3 wrote > See https://www.sqlite.org/fileformat.html#the_sqlite_stat4_table
Thanks, I have already read it, but there is no explanation about this: korablev wrote > statistics in the second row seems to be wrong: there are 0 rows which are > less than 1(for the reason that the only value in that index is 1). And > why do nLt and nDLt columns consist of 2 slots instead of 1(index consists > only of 1 column + 1 PK which shouldn't be taken into account)? Probably the main question is not "why there are 2 samples for 1 value", but "why there is so strange (if not wrong) statistics?". -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
