dan
|
4bc39fa188
|
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.
FossilOrigin-Name: 6611b76b0296875fb9903b25dfaa783a9c12eaa1
|
2010-11-13 16:42:27 +00:00 |
|
dan
|
acf1987d18
|
Fix a bug in the EXPLAIN QUERY PLAN code.
FossilOrigin-Name: 7ae068952fba4395b4aa437613a5ed2bd9ddf941
|
2010-11-11 11:43:01 +00:00 |
|
dan
|
47eb16d4ce
|
Modifications to test cases to account for new EXPLAIN QUERY PLAN output.
FossilOrigin-Name: 30904ef8412348464e893e9e1551ef22cad24a3e
|
2010-11-11 10:36:25 +00:00 |
|
drh
|
dda70fe38e
|
Remove leftover "breakpoint" commands from test scripts. Also remove blank
lines at the end of scripts. (CVS 6721)
FossilOrigin-Name: 1fef16ec2b89981770cf44f606a420fbe031a7a4
|
2009-06-05 17:09:11 +00:00 |
|
danielk1977
|
1d46146b58
|
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527)
FossilOrigin-Name: f61e4cd93682fd98bea2a71d346f9eaa68454390
|
2009-04-21 09:02:45 +00:00 |
|
danielk1977
|
a55331620e
|
Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316)
FossilOrigin-Name: d4aa6593183224b6868a322511511c0bbf63b598
|
2009-02-24 10:01:51 +00:00 |
|
danielk1977
|
e2d7b24d08
|
Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315)
FossilOrigin-Name: 294ba6f743c9132dce0e73da480bd3c2071e7239
|
2009-02-23 17:33:49 +00:00 |
|
drh
|
103bd88cf7
|
Increased test coverage in where.c. (CVS 6146)
FossilOrigin-Name: 1e5725c5179660277c2e8c321877d7ee3ca21808
|
2009-01-08 21:00:02 +00:00 |
|
drh
|
171256c45c
|
Increase test coverage of where.c. Make sure OR-optimization works on
UPDATE and DELETE in addition to SELECT. (Bug found by coverage tests.) (CVS 6139)
FossilOrigin-Name: 4b2c08e8984befb12fa2173ca89d9f54cf764d22
|
2009-01-08 03:11:19 +00:00 |
|
drh
|
04bbcd5ce9
|
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint"
commands from test scripts. (CVS 6086)
FossilOrigin-Name: b090d5736d7eaec17a39d3133e1587b1d2a42acb
|
2008-12-30 17:55:00 +00:00 |
|
drh
|
eb9441eb06
|
Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)
FossilOrigin-Name: 96f3b62914adde34079f08428b4e2fe81c193612
|
2008-12-30 16:35:53 +00:00 |
|
drh
|
46129af9fb
|
Get EXPLAIN QUERY PLAN working with the multi-index OR optimization.
Added new test script "where9.test". (CVS 6084)
FossilOrigin-Name: 4b6460221011e02bedb724169e8e4793e539e65a
|
2008-12-30 16:18:47 +00:00 |
|