Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/eqp.test
|
2018-12-24
| ||
| 20:21 | Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. file: [84879b63] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 21516 | |
| 12:09 | Do not generate subroutines for non-static SELECT and EXISTS expressions. Fix up some test cases to account for the minor changes in EXPLAIN QUERY PLAN output. file: [5e8b1b2d] check-in: [06de44ec] user: drh branch: reuse-subqueries, size: 21398 | |
|
2018-08-16
| ||
| 15:29 | Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using a ROWID lookup. file: [fc00ad1a] check-in: [60045fbf] user: drh branch: trunk, size: 21384 | |
|
2018-05-04
| ||
| 00:39 | Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. file: [4fd69d25] check-in: [75ac7b4e] user: drh branch: trunk, size: 19123 | |
|
2018-05-03
| ||
| 01:37 | Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. file: [2ac18a1d] check-in: [c75eee69] user: drh branch: rework-EQP, size: 19071 | |
|
2018-05-02
| ||
| 14:24 | Fix a dangling-else problem that was causing recursive CTEs to malfunction. Begin fixing test cases to work with the new EQP output. file: [0d06518e] check-in: [82ca44b8] user: drh branch: rework-EQP, size: 18885 | |
|
2017-06-22
| ||
| 16:51 | When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. file: [3f9ba0b2] check-in: [e4a022be] user: dan branch: or-optimization, size: 18285 | |
|
2016-03-14
| ||
| 17:05 | Many test cases fixed to work with encryption. file: [3fe051af] check-in: [d866fffb] user: drh branch: see-testing, size: 18285 | |
|
2015-06-10
| ||
| 17:20 | Resolve FROM-clause subqueries after query planning instead of before. Greatly reduce the estimated cost of automatic indexes for VIEWs and ephemeral tables since performance problems there cannot be mitigated via a CREATE INDEX. file: [bd139cee] check-in: [a1eaf171] user: drh branch: view-optimization, size: 18182 | |
|
2014-05-23
| ||
| 17:17 | Changes to the output of EXPLAIN QUERY PLAN to make it clearer when a query uses the PRIMARY KEY index of a WITHOUT ROWID table. file: [85873fa5] check-in: [9268df30] user: dan branch: trunk, size: 18182 | |
|
2014-04-30
| ||
| 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. file: [90b56d03] check-in: [9b975bf3] user: dan branch: experimental-costs, size: 17284 | |
|
2013-10-04
| ||
| 15:58 | Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. file: [57c6c604] check-in: [2f394de8] user: drh branch: index-scan-rate, size: 17191 | |
| 02:36 | Progress toward using the iScanRatio information on indices. Many tests are still failing. file: [d4386348] check-in: [6c352edb] user: drh branch: index-scan-rate, size: 17143 | |
|
2013-08-02
| ||
| 23:40 | Updates to requirements marks. No code changes. file: [d9e7ad4e] check-in: [21302076] user: drh branch: trunk, size: 16984 | |
|
2013-06-12
| ||
| 17:08 | "make test" now passing. file: [8ef4d89d] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 16952 | |
|
2013-06-11
| ||
| 01:50 | Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. file: [68dd66c8] check-in: [e612664a] user: drh branch: nextgen-query-plan-logcost, size: 16952 | |
|
2013-06-10
| ||
| 23:30 | Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [ac506be9] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 16976 | |
|
2012-09-17
| ||
| 20:44 | Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. file: [46aa946d] check-in: [ccb8ecc3] user: drh branch: fullscan-covering-index, size: 18859 | |
|
2012-09-15
| ||
| 18:45 | 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. file: [103243f8] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 18859 | |
|
2012-02-13
| ||
| 10:00 | Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [6a389bba] check-in: [76bb649e] user: dan branch: trunk, size: 18661 | |
|
2011-02-21
| ||
| 17:49 | Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl". file: [f14fadd7] check-in: [9f9f3288] user: dan branch: trunk, size: 18613 | |
|
2011-01-28
| ||
| 01:57 | Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. file: [8f535d90] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 17596 | |
|
2010-11-16
| ||
| 02:49 | Use the estimated number of rows computed for subqueries in the cost computations for outer queries. file: [69670e79] check-in: [56bbc539] user: drh branch: trunk, size: 17596 | |
|
2010-11-15
| ||
| 21:50 | Change the EQP output for the min/max optimization from "SCAN" to "SEARCH". Other changes in where.c in support of full branch coverage testing. file: [7cc9b11f] check-in: [d52b5939] user: drh branch: trunk, size: 16447 | |
| 16:12 | Change some test cases to account for the new EXPLAIN QUERY PLAN output. file: [0a76679d] check-in: [88a854e1] user: dan branch: trunk, size: 16444 | |
| 14:51 | Test some example code from documentation page eqp.html. file: [32567e06] check-in: [547bc2c2] user: dan branch: trunk, size: 16557 | |
|
2010-11-13
| ||
| 16:42 | Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. file: [8f8e8ca5] check-in: [6611b76b] user: dan branch: experimental, size: 15482 | |
|
2010-11-12
| ||
| 17:41 | Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. file: [4ca41a9f] check-in: [85fdad85] user: dan branch: experimental, size: 15317 | |
|
2010-11-11
| ||
| 17:48 | Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. file: [13c875a9] check-in: [28643b85] user: dan branch: experimental, size: 9761 | |
| 16:46 | Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. file: [d4a411b2] check-in: [00fb8468] user: dan branch: experimental, size: 9775 | |
| 10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [b5737656] check-in: [30904ef8] user: dan branch: experimental, size: 8512 | |
|
2010-11-09
| ||
| 14:49 | Further enhancements and fixes for explain query plan. file: [a63c03a3] check-in: [73c93f5a] user: dan branch: experimental, size: 7907 | |
|
2010-11-08
| ||
| 19:01 | Experimental changes to EXPLAIN QUERY PLAN. file: [d8ad22f6] check-in: [f4747eb8] user: dan branch: experimental, size: 5217 Added | |