/ Check-in [d09ca6d5]
Login

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

Overview
Comment:Attempt to use STAT4 information to estimate the selectivity of WHERE clause terms when using the skip-scan optimization.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d09ca6d5efad3e4cfa93a4dc711e6ba6079d4b4b
User & Date: drh 2014-06-30 19:07:58
References
2014-07-24
22:41
Fix a bug in the whereRangeSkipScanEst() procedure (added by check-in [d09ca6d5efad3e4cfa]) where it fails to consider the possibility of a ROWID column when computing the affinity of a table column. check-in: 6aea2258 user: drh tags: trunk
Context
2014-06-30
19:28
Bump the version number to 3.8.6. check-in: f925e9ba user: drh tags: trunk
19:07
Attempt to use STAT4 information to estimate the selectivity of WHERE clause terms when using the skip-scan optimization. check-in: d09ca6d5 user: drh tags: trunk
18:57
Fix for ticket [b2fa5424e6fcb15]: Better define the format of the sqlite_stat4 file for WITHOUT ROWID tables and make sure the ANALYZE command generates a file in the appropriate format. Use the sqlite_stat4 data to enable the use of WHERE terms that cover all indexed columns plus some prefix of columns in the primary key. check-in: bc2de809 user: drh tags: trunk
2014-06-28
19:06
Add an OOM fault injection test for the new code on this branch. Closed-Leaf check-in: c96de490 user: dan tags: stat4-skipscan
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/sqliteInt.h.

Changes to src/vdbe.h.

Changes to src/vdbeInt.h.

Changes to src/vdbeaux.c.

Changes to src/vdbemem.c.

Changes to src/where.c.

Changes to test/mallocK.test.

Added test/skipscan5.test.