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: |
bc446449a19171c0fa0681973b06bc80 |
| 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
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.