/ Check-in [bc446449]
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:Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bc446449a19171c0fa0681973b06bc80d3c0517f
User & Date: drh 2013-09-13 17:47:57
Context
2013-09-13
18:15
Remove one unreachable branch and add asserts() to dupedExprStructSize(). New asserts verify that removed branch is unused and that constants that are ORed together in the output do not overlap. check-in: 86ad358b user: drh tags: trunk
17:47
Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms. check-in: bc446449 user: drh tags: trunk
16:56
Enhance the pragma lookup table generator script to output a comment that gives the number of pragmas. check-in: ca052050 user: drh tags: trunk
2013-09-12
23:42
Refactor the ExprSetIrreducible() macro into ExprSetVVAProperty(*,EP_NoReduce). This is a naming change only. The logic is the same. Closed-Leaf check-in: 695aee46 user: drh tags: unlikely-func
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/attach.c.

Changes to src/expr.c.

Changes to src/func.c.

Changes to src/parse.y.

Changes to src/resolve.c.

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to src/walker.c.

Changes to src/where.c.

Changes to test/analyze9.test.

Added test/whereG.test.