/ Check-in [3e0590de]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. This generates more accurate estimates.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3e0590dee0e68cc1599858757c650a7378026170
User & Date: dan 2015-03-16 16:28:43
References
2017-05-24
04:32
Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. check-in: 19dad0a7 user: drh tags: branch-3.8.9
04:18
Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. check-in: cfb0d9e0 user: drh tags: trunk
Context
2015-03-16
16:44
When deleting the master journal to commit a multi-database transaction, do not sync the directory if PRAGMA synchronous=OFF for all participating database files. check-in: 018d7671 user: drh tags: trunk
16:28
When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. This generates more accurate estimates. check-in: 3e0590de user: dan tags: trunk
13:48
Use #ifdef to omit code that is only used for STAT3 and STAT4. check-in: f2c9c5b5 user: drh tags: trunk
09:21
Another test case for the planner change on this branch. Closed-Leaf check-in: f2207a06 user: dan tags: stat4-change
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to test/analyze9.test.