SQLite

Changes On Branch experimental-costs
Login

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

Changes In Branch experimental-costs Excluding Merge-Ins

This is equivalent to a diff from af2cbe64 to 05e6e16c

2014-04-30
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)
14:53
Update a couple of test cases to account for the fact that this branch prefers an index scan and partial sort over a full-table scan and full external sort. (check-in: 9b975bf3 user: dan tags: experimental-costs)
2014-04-29
16:46
Merge trunk changes into this branch. (check-in: d74299f0 user: dan tags: experimental-costs)
2014-04-28
18:02
Merge all recent trunk enhancements and fixes into the sessions branch. (check-in: e158812c user: drh tags: sessions)
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)
17:51
Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (check-in: 3dca2809 user: drh tags: sessions)
2014-04-26
19:23
Update requirements marks to fix typos in the requirements text. No changes to code. (check-in: f5a26365 user: drh tags: trunk)

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.