/ Timeline
Login

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

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: 90e3667647 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: 05e6e16cb2 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: 9b975bf33c user: dan tags: experimental-costs
14:47
Fix a couple of out-of-date comments in where.c. check-in: eefeda32d5 user: dan tags: experimental-costs
14:22
Improved rendering of LogEst values corresponding to real values near 0.0 in the tool/logest.c utility program. check-in: 32910c8c59 user: drh tags: experimental-costs
13:19
Fix long-standing typos in comments. check-in: b9f91317c3 user: drh tags: experimental-costs
2014-04-29
19:01
Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. check-in: e2d42f909d user: dan tags: experimental-costs
16:46
Merge trunk changes into this branch. check-in: d74299f037 user: dan tags: experimental-costs
16:10
Ignore likelihood() values on indexed IPK lookups. check-in: 5bb7757a7b user: dan tags: experimental-costs
12:01
Fix a test case so that it updates sqlite_stat1 consistently. check-in: 2dc5a0b555 user: dan tags: experimental-costs
2014-04-28
20:11
Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. check-in: a8ae93f0cf user: dan tags: experimental-costs
19:34
The trunk assumes that an open range constraint on an indexed term (col>?) term matches 1/4 of the indexed rows, and that a closed constraint (col BETWEEN ? AND ?) matches 1/64. Change this branch to do the same. check-in: 4047ac75e2 user: dan tags: experimental-costs
17:56
Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (Cherrypick from the sessions branch.) check-in: af2cbe64ad user: drh tags: trunk
15:11
Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 20f468dfbc user: dan tags: experimental-costs
12:08
Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. check-in: 1b95544f84 user: dan tags: experimental-costs
10:00
Update test script analyze3.test to account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 35f46a55d8 user: dan tags: experimental-costs
09:35
Modify internal function whereLoopAdjustCost() so that it does not prefer a skip-scan over a regular index scan even if the regular scan uses a subset of the WHERE terms used by the skip-scan. check-in: 88a5758dcc user: dan tags: experimental-costs
08:49
Fix an error in estimating of the number of rows visited by a range scan. check-in: d491de62fc user: dan tags: experimental-costs
2014-04-26
20:21
Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. check-in: dee2040924 user: dan tags: experimental-costs
2014-04-25
20:22
If the user provides likelihood() data for a WHERE clause term used as part of an index key, have the planner use it when calculating the expected number of rows visited by the loop. check-in: c51efaa5d2 user: dan tags: experimental-costs
15:01
Store values loaded from the stat1 table as logarithmic values in memory. check-in: 1bd74c49dd user: dan tags: experimental-costs
2014-04-24
20:04
Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. check-in: c5a6ec0a88 user: dan tags: experimental-costs
2014-04-21
13:36
Comment tweaks on the test case for the [b75a9ca6b0] bug fix. check-in: 65d2544af9 user: drh tags: trunk