/ Check-in [90e36676]
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:Modify the way the costs of various query plans are estimated. If the user supplies a likelihood() value (or equivalent) on an indexed WHERE constraint, use it to estimate the number of index rows visited.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 90e36676476e8db00658772e6c938242f766d306
User & Date: dan 2014-04-30 15:22:25
References
2019-08-15
14:28 New ticket [e4598ecb] Division by zero in the query planner.. artifact: d93508fc user: drh
2015-04-11
11:06 New ticket [7b4fee9f] Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only. artifact: a72fb3c9 user: dan
Context
2014-04-30
18:11
Fix a problem in calculating the costs of "OR" scans. check-in: 9bbca48b user: dan tags: trunk
15:22
Modify the way the costs of various query plans are estimated. If the user supplies a likelihood() value (or equivalent) on an indexed WHERE constraint, use it to estimate the number of index rows visited. check-in: 90e36676 user: dan tags: trunk
15:00
Add text to the header comment of whereLoopAddBtree() describing how the costs of various b-tree loops are estimated. Closed-Leaf check-in: 05e6e16c user: dan tags: experimental-costs
2014-04-28
17:56
Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (Cherrypick from the sessions branch.) check-in: af2cbe64 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/analyze.c.

Changes to src/build.c.

Changes to src/pragma.c.

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to src/util.c.

Changes to src/where.c.

Changes to src/whereInt.h.

Changes to test/analyze3.test.

Changes to test/analyze9.test.

Changes to test/autoindex1.test.

Added test/cost.test.

Changes to test/eqp.test.

Changes to test/index6.test.

Changes to test/orderby5.test.

Changes to test/skipscan2.test.

Changes to test/unordered.test.

Changes to test/where3.test.

Changes to test/whereG.test.

Changes to tool/logest.c.