Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/eqp.test
|
2018-12-24
| ||
| 20:21 | [84879b63] part of check-in [7153552b] 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. (check-in: [7153552b] user: drh branch: reuse-subqueries, size: 21516) | |
| 12:09 | [5e8b1b2d] part of check-in [06de44ec] 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. (check-in: [06de44ec] user: drh branch: reuse-subqueries, size: 21398) | |
|
2018-08-16
| ||
| 15:29 | [fc00ad1a] part of check-in [60045fbf] Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using a ROWID lookup. (check-in: [60045fbf] user: drh branch: trunk, size: 21384) | |
|
2018-05-04
| ||
| 00:39 | [4fd69d25] part of check-in [75ac7b4e] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e] user: drh branch: trunk, size: 19123) | |
|
2018-05-03
| ||
| 01:37 | [2ac18a1d] part of check-in [c75eee69] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69] user: drh branch: rework-EQP, size: 19071) | |
|
2018-05-02
| ||
| 14:24 | [0d06518e] part of check-in [82ca44b8] Fix a dangling-else problem that was causing recursive CTEs to malfunction. Begin fixing test cases to work with the new EQP output. (check-in: [82ca44b8] user: drh branch: rework-EQP, size: 18885) | |
|
2017-06-22
| ||
| 16:51 | [3f9ba0b2] part of check-in [e4a022be] 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. (check-in: [e4a022be] user: dan branch: or-optimization, size: 18285) | |
|
2016-03-14
| ||
| 17:05 | [3fe051af] part of check-in [d866fffb] Many test cases fixed to work with encryption. (check-in: [d866fffb] user: drh branch: see-testing, size: 18285) | |
|
2015-06-10
| ||
| 17:20 | [bd139cee] part of check-in [a1eaf171] 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. (check-in: [a1eaf171] user: drh branch: view-optimization, size: 18182) | |
|
2014-05-23
| ||
| 17:17 | [85873fa5] part of check-in [9268df30] 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. (check-in: [9268df30] user: dan branch: trunk, size: 18182) | |
|
2014-04-30
| ||
| 14:53 | [90b56d03] part of check-in [9b975bf3] 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 branch: experimental-costs, size: 17284) | |
|
2013-10-04
| ||
| 15:58 | [57c6c604] part of check-in [2f394de8] 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. (check-in: [2f394de8] user: drh branch: index-scan-rate, size: 17191) | |
| 02:36 | [d4386348] part of check-in [6c352edb] Progress toward using the iScanRatio information on indices. Many tests are still failing. (check-in: [6c352edb] user: drh branch: index-scan-rate, size: 17143) | |
|
2013-08-02
| ||
| 23:40 | [d9e7ad4e] part of check-in [21302076] Updates to requirements marks. No code changes. (check-in: [21302076] user: drh branch: trunk, size: 16984) | |
|
2013-06-12
| ||
| 17:08 | [8ef4d89d] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 16952) | |
|
2013-06-11
| ||
| 01:50 | [68dd66c8] part of check-in [e612664a] Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. (check-in: [e612664a] user: drh branch: nextgen-query-plan-logcost, size: 16952) | |
|
2013-06-10
| ||
| 23:30 | [ac506be9] 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: 16976) | |
|
2012-09-17
| ||
| 20:44 | [46aa946d] part of check-in [ccb8ecc3] 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. (check-in: [ccb8ecc3] user: drh branch: fullscan-covering-index, size: 18859) | |
|
2012-09-15
| ||
| 18:45 | [103243f8] 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: 18859) | |
|
2012-02-13
| ||
| 10:00 | [6a389bba] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 18661) | |
|
2011-02-21
| ||
| 17:49 | [f14fadd7] part of check-in [9f9f3288] Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl". (check-in: [9f9f3288] user: dan branch: trunk, size: 18613) | |
|
2011-01-28
| ||
| 01:57 | [8f535d90] part of check-in [4847c6cb] 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. (check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 17596) | |
|
2010-11-16
| ||
| 02:49 | [69670e79] part of check-in [56bbc539] Use the estimated number of rows computed for subqueries in the cost computations for outer queries. (check-in: [56bbc539] user: drh branch: trunk, size: 17596) | |
|
2010-11-15
| ||
| 21:50 | [7cc9b11f] part of check-in [d52b5939] 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. (check-in: [d52b5939] user: drh branch: trunk, size: 16447) | |
| 16:12 | [0a76679d] part of check-in [88a854e1] Change some test cases to account for the new EXPLAIN QUERY PLAN output. (check-in: [88a854e1] user: dan branch: trunk, size: 16444) | |
| 14:51 | [32567e06] part of check-in [547bc2c2] Test some example code from documentation page eqp.html. (check-in: [547bc2c2] user: dan branch: trunk, size: 16557) | |
|
2010-11-13
| ||
| 16:42 | [8f8e8ca5] part of check-in [6611b76b] 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. (check-in: [6611b76b] user: dan branch: experimental, size: 15482) | |
|
2010-11-12
| ||
| 17:41 | [4ca41a9f] part of check-in [85fdad85] Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. (check-in: [85fdad85] user: dan branch: experimental, size: 15317) | |
|
2010-11-11
| ||
| 17:48 | [13c875a9] part of check-in [28643b85] Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. (check-in: [28643b85] user: dan branch: experimental, size: 9761) | |
| 16:46 | [d4a411b2] part of check-in [00fb8468] Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. (check-in: [00fb8468] user: dan branch: experimental, size: 9775) | |
| 10:36 | [b5737656] part of check-in [30904ef8] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef8] user: dan branch: experimental, size: 8512) | |
|
2010-11-09
| ||
| 14:49 | [a63c03a3] part of check-in [73c93f5a] Further enhancements and fixes for explain query plan. (check-in: [73c93f5a] user: dan branch: experimental, size: 7907) | |
|
2010-11-08
| ||
| 19:01 | [d8ad22f6] part of check-in [f4747eb8] Experimental changes to EXPLAIN QUERY PLAN. (check-in: [f4747eb8] user: dan branch: experimental, size: 5217) Added | |