]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9684d71) | patch
When computing STAT1 values using ANALYZE, if a ratio comes out to be between
authordrh <>
Wed, 27 Apr 2022 16:41:56 +0000 (16:41 +0000)
committerdrh <>
Wed, 27 Apr 2022 16:41:56 +0000 (16:41 +0000)
commit609959285bc035aa18da0d89bea484e1b5432105
tree78ef4c354277499766150e0fb643518026b77d37tree
parent9684d71081fd07cd79f2738f7bfd83cde3aa49a0commit | diff
When computing STAT1 values using ANALYZE, if a ratio comes out to be between
1.0 and 1.1, then round it down to 1 rather than the using the default rounding
rule of changing it to 2.  The reduces the estimation error for the
case where a column value is very nearly, but not quite unique.

FossilOrigin-Name: eb59c46a5aed69bc6fd096997bf24c082e533c1085439f6ec1fbe5ff78e8b374
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/analyze.c diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git