Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
2018-05-02
| ||
| 18:00 | [ffeea774] part of check-in [5f0e803e] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 2205) | |
|
2014-04-28
| ||
| 15:11 | [ca7adce0] part of check-in [20f468df] 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: [20f468df] user: dan branch: experimental-costs, size: 2351) | |
|
2013-06-12
| ||
| 17:08 | [ef85ac8f] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 2348) | |
|
2013-06-10
| ||
| 23:30 | [08b4ea1c] part of check-in [aa580e36] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 2383) | |
|
2012-09-15
| ||
| 18:45 | [93dce7b6] part of check-in [cfaa7bc1] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 2525) | |
|
2011-08-26
| ||
| 13:52 | [279856a6] part of check-in [0df04f92] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 2380) | |
|
2011-08-13
| ||
| 19:35 | [f53095ce] part of check-in [89b2f708] Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. (check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 2501) | |
|
2011-04-15
| ||
| 15:18 | Added: [87ecfbb6] part of check-in [8d924e16] Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. (check-in: [8d924e16] user: drh branch: branch-3.7.2, size: 2304) | |
| 14:46 | [e81169ce] part of check-in [a8761a91] Do not do full table scans of unordered indices. (check-in: [a8761a91] user: drh branch: trunk, size: 2425) | |
|
2011-04-09
| ||
| 19:17 | Added: [c479d302] part of check-in [f346dae1] Add test file unordered.test. (check-in: [f346dae1] user: dan branch: trunk, size: 2280) | |