Documentation Source Text

All files named "pages/optoverview.in"
Login

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

History for pages/optoverview.in

2024-07-24
12:16
[f3bc76d394] part of check-in [e11c23e9c7] Rename WHERE-clause push-down optimization to predicate push-down. (check-in: [e11c23e9c7] user: drh branch: branch-3.46, size: 61993)
2024-07-23
19:09
[4eb4d15acd] part of check-in [155cc10ec0] Begin constructing a change log for the 3.47.0 release. (check-in: [155cc10ec0] user: drh branch: trunk, size: 61994)
2024-05-10
14:15
[8909f126d6] part of check-in [9316ff2178] A few more tweaks to query planner documentation. (check-in: [9316ff2178] user: drh branch: trunk, size: 61968)
13:53
[2a8d0dda9c] part of check-in [11a5959318] Further improvements to the optimizer documentation. (check-in: [11a5959318] user: drh branch: trunk, size: 62035)
11:16
[6f76482017] part of check-in [a422b5fc9e] Updates to the query planner documents. This is but one small change in what will probably end up being a long series of improvements. (check-in: [a422b5fc9e] user: drh branch: trunk, size: 60898)
2024-05-09
17:36
[3167921e6b] part of check-in [13bb2276fe] Add "query-time index" as an alternative to "automatic index". (check-in: [13bb2276fe] user: drh branch: trunk, size: 59681)
2024-04-10
13:05
[cc5f8f396e] part of check-in [798b43b807] Disambiguate the WHERE-clause push-down optimization and the MySQL push-down optimization. (check-in: [798b43b807] user: drh branch: trunk, size: 59518)
2024-03-18
23:31
[abc7e0b917] part of check-in [8daf6750f4] Improvements to query planner documentation. (check-in: [8daf6750f4] user: drh branch: trunk, size: 58781)
2024-01-13
19:04
[be9cc8690c] part of check-in [0b88a38dfd] Fix typos. Add a new CVE. (check-in: [0b88a38dfd] user: drh branch: branch-3.44, size: 58754)
2023-06-01
20:46
[ac75d82d3e] part of check-in [1486a61269] Document the enhancement to the OUTER JOIN strength reduction optimization. (check-in: [1486a61269] user: drh branch: trunk, size: 58755)
18:28
[aefbe2016d] part of check-in [4635dbba87] Generalize the documentation on the LEFT JOIN strength reduction and omit-LEFT-JOIN optimizations to talk about RIGHT and FULL JOINs as well. The implementation of those optimizations still only works for LEFT JOIN, so in some sense the documentation is getting ahead of the implementation. (check-in: [4635dbba87] user: drh branch: trunk, size: 58945)
2023-02-27
00:41
[2d4bcf2cf8] part of check-in [2f4ea6952b] Spelling and spell-check improvements. (linecount /= 56) (check-in: [2f4ea6952b] user: larrybr branch: trunk, size: 58137)
2023-02-11
20:57
[2016d0b218] part of check-in [e75646d8c9] Updates to the change log. Minor tweaks to other docs to which the change log refers. (check-in: [e75646d8c9] user: drh branch: trunk, size: 58138)
2022-09-19
12:27
[f697eab2d8] part of check-in [1ddadab8ef] Minor tweaks to query optimizer documentation. (check-in: [1ddadab8ef] user: drh branch: trunk, size: 58111)
2022-05-10
17:29
[6df00da290] part of check-in [91f7d0cc38] Tweaks to documentation in support or RIGHT and FULL JOIN. (check-in: [91f7d0cc38] user: drh branch: trunk, size: 58105)
2021-11-30
14:49
[5ca32b3fb5] part of check-in [9bb8566076] Add a brief note to explain that a query that uses an automatic index is what other database engines might call a "hash join". (check-in: [9bb8566076] user: drh branch: trunk, size: 58109)
2021-06-17
16:11
[de1ca04012] part of check-in [340f253778] Fix typos in recent changes. (check-in: [340f253778] user: dan branch: trunk, size: 57057)
2021-05-17
18:22
[e9a2278caf] part of check-in [563e46304a] Mention the improvement to the constant-propagation optimization in the change log. (check-in: [563e46304a] user: drh branch: trunk, size: 57056)
2021-01-18
13:20
[06a5493c62] part of check-in [e242010054] Update the change log to show the latest enhancements. (check-in: [e242010054] user: drh branch: trunk, size: 56082)
2020-12-18
13:14
[d8b68c1415] part of check-in [a10f56ec91] Fix typo in optoverview.html (check-in: [a10f56ec91] user: drh branch: branch-3.34, size: 56059)
2020-12-17
23:48
[f468c5ff5b] part of check-in [daa9d19197] Fix typos in SQL in the optoverview.html. (check-in: [daa9d19197] user: drh branch: branch-3.34, size: 56060)
2020-12-16
23:13
[561a2e6a21] part of check-in [0b0f215c92] Editorial changes to the optoverview.html document. (check-in: [0b0f215c92] user: drh branch: branch-3.34, size: 56069)
2020-08-20
11:32
[96aaba116e] part of check-in [c5f5f967d1] Fix formatting error in the optoverview.html document. (check-in: [c5f5f967d1] user: drh branch: trunk, size: 57050)
2020-04-21
01:32
[a3a8e0a6de] part of check-in [b2b73614f4] Fix typo in the optoverview.html document. (check-in: [b2b73614f4] user: drh branch: branch-3.31, size: 57038)
2018-11-24
20:24
[78717d462e] part of check-in [9e12c649c9] Minor enhancements and updates to various documents. (check-in: [9e12c649c9] user: drh branch: trunk, size: 57034)
2018-05-31
19:14
[655f8eaaf1] part of check-in [db85f0efae] Typo fixes. (check-in: [db85f0efae] user: drh branch: trunk, size: 57020)
2018-04-12
17:04
[954b3bdc70] part of check-in [5272d8d61d] Fix a typo on the optoverview.html document. (check-in: [5272d8d61d] user: drh branch: trunk, size: 57021)
2018-03-30
17:15
[154fbdc63c] part of check-in [2f6a562725] Fix a close-requirement mark in optoverview.html. (check-in: [2f6a562725] user: drh branch: trunk, size: 57021)
2018-03-23
14:53
[19e17d4225] part of check-in [9e6750c1fc] Clarification of text in the new optoverview.html section on the LEFT JOIN Optimization. (check-in: [9e6750c1fc] user: drh branch: trunk, size: 57020)
11:47
[194270f888] part of check-in [79f3efbc86] Fix typos. Clarification to the CoC in response to criticism. (check-in: [79f3efbc86] user: drh branch: trunk, size: 57027)
2018-03-22
18:55
[2a6452a491] part of check-in [219fa13637] Further enhancement to the optimizer overview document, giving the change log for 3.23.0 something to link to. (check-in: [219fa13637] user: drh branch: trunk, size: 57026)
13:36
[ff454b22aa] part of check-in [69fd8c5ba9] Refactor the optoverview.html document to be written in HTML with occasional <tcl> tags, rather than in pure TCL, so that it works better with fancy-format. (check-in: [69fd8c5ba9] user: drh branch: trunk, size: 52306)
2018-02-01
14:43
[89e702770e] part of check-in [20ecb45b42] Fix a typo in the flattening rules of the optoverview.html document. (check-in: [20ecb45b42] user: drh branch: branch-3.22, size: 53198)
2018-01-26
15:50
[0ee7cdbe02] part of check-in [98e66068fe] Turn on "fancy-format" for the optoverview.html document. (check-in: [98e66068fe] user: drh branch: trunk, size: 53202)
15:44
[92ad6238c9] part of check-in [a599e76d95] Bring the query flattening section of the optoverview.html document up to date with version 3.22.0. (check-in: [a599e76d95] user: drh branch: trunk, size: 53224)
2017-10-04
16:16
[ec59257d09] part of check-in [9cf55de770] In the co-routine documentation, mention that future versions of SQLite might make smarter transformations. (check-in: [9cf55de770] user: drh branch: trunk, size: 52349)
15:53
[0bfbd93c29] part of check-in [18d1ad0854] Improvements to the co-routine documentation. (check-in: [18d1ad0854] user: drh branch: trunk, size: 51954)
2017-10-02
03:42
[415b6523c1] part of check-in [7e35a79626] Mention changes to the use of co-routines in the change log. Provide information on co-routines in the query planner overview document. (check-in: [7e35a79626] user: drh branch: trunk, size: 50668)
2017-08-03
20:39
[5530c6137d] part of check-in [4cadcc5b9c] Begin a change log entry for the 3.21.0 release. (check-in: [4cadcc5b9c] user: drh branch: trunk, size: 48198)
2017-06-29
18:17
[0eda4b542e] part of check-in [3c1197562c] Add documentation for the STMT virtual table (check-in: [3c1197562c] user: drh branch: trunk, size: 48224)
2017-04-18
11:52
[3909efd58f] part of check-in [d26b238e7e] Update to the flattening optimization description in the optoverview.html page. Add a new bullet to the change log for 3.19.0. (check-in: [d26b238e7e] user: drh branch: trunk, size: 48202)
2017-03-15
20:51
[c4d63ac5a5] part of check-in [7c122e0975] Update the details of when the LIKE optimization is allowed, due to enhancements to the LIKE optimization logic in 3.18.0. (check-in: [7c122e0975] user: drh branch: trunk, size: 48162)
2016-10-31
13:19
[6f89f2bfd1] part of check-in [e5277d7908] Additional cross-referencing of query planner documents. (check-in: [e5277d7908] user: drh branch: trunk, size: 47574)
2016-09-14
18:40
[7d14f646cb] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 47471)
2015-11-02
14:10
[d24cee4073] part of check-in [6910bdfa2a] Add a note to help clarify that automatic indexes and internal indexes used to implement PRIMARY KEY and UNIQUE constraints are unrelated. (check-in: [6910bdfa2a] user: drh branch: trunk, size: 47452)
2015-10-07
19:40
[b4a057ccaa] part of check-in [47d33de042] Link the optoverview.html document to the new expridx.html document. (check-in: [47d33de042] user: drh branch: trunk, size: 46770)
2015-07-23
22:05
[498b05633f] part of check-in [12a7bb44f4] Improvements to the change log. (check-in: [12a7bb44f4] user: drh branch: trunk, size: 46494)
2015-07-13
22:07
[dd10fc5b35] part of check-in [a5dfd4a26b] First cut at OTA documentation. (check-in: [a5dfd4a26b] user: drh branch: trunk, size: 46476)
2015-01-07
12:53
[703014936f] part of check-in [1e0e7c9300] Write ESCAPE instead of EXCEPT as the modifier for the LIKE operator. (check-in: [1e0e7c9300] user: drh branch: trunk, size: 46615)
2014-08-14
13:06
[b4dd7207d5] part of check-in [09088d9a21] Fix typos. (check-in: [09088d9a21] user: drh branch: trunk, size: 46615)
2014-05-25
20:08
[3a9c8e70ca] part of check-in [fc0e9baa66] Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. (check-in: [fc0e9baa66] user: drh branch: trunk, size: 46619)
2013-11-27
04:26
[d4c21a1f2d] part of check-in [3eaa7f572e] Update the skip-scan documentation to mention the magic 18 number for when skip-scan becomes profitable. (check-in: [3eaa7f572e] user: drh branch: trunk, size: 45342)
2013-11-18
18:48
[ff4ea75ff5] part of check-in [b8e6ac4ce4] Fix documentation typos pointed out on the mailing list by Philip Newton. (check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 45244)
2013-11-13
22:39
[bffb181541] part of check-in [9b1dc53b75] Update the change log to show the skip-scan optimization and other recent changes. Add documentation on skip-scan. (check-in: [9b1dc53b75] user: drh branch: trunk, size: 45244)
2013-10-19
16:21
[8de0e412c9] part of check-in [0998ee24a4] Updates to documentation for recent changes, especially the unlikely() function and STAT4. Also fix some typos. (check-in: [0998ee24a4] user: drh branch: trunk, size: 41174)
2013-08-28
14:13
[ad059797c1] part of check-in [04ab4fa5ec] Add documentation for STAT4. (check-in: [04ab4fa5ec] user: drh branch: trunk, size: 41176)
2013-08-23
16:16
[b204ac5efa] part of check-in [ce2a4ec1e7] Fix documentation typos. (check-in: [ce2a4ec1e7] user: drh branch: trunk, size: 40846)
2013-07-01
16:07
[afb4bd113f] part of check-in [641e107a66] Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. (check-in: [641e107a66] user: drh branch: trunk, size: 40846)
2011-12-30
14:57
[885eed68fe] part of check-in [986229bc47] Major speed improvement on the script that translates requirements. Fix requirements markup in optoverview.html and in fileformat2.html. Fixes to requirements.html. (check-in: [986229bc47] user: drh branch: trunk, size: 38495)
2011-10-07
23:26
[b456f0f719] part of check-in [4b78e06344] Update documentation for SQLITE_ENABLE_STAT3. (check-in: [4b78e06344] user: drh branch: trunk, size: 38495)
2011-06-20
21:48
[a2b0c9e324] part of check-in [b503d1f516] Documentation typos. (check-in: [b503d1f516] user: drh branch: trunk, size: 38495)
2010-11-10
18:43
[430c621966] part of check-in [37f6e9f261] Add some more documentation for EXPLAIN QUERY PLAN. (check-in: [37f6e9f261] user: dan branch: trunk, size: 38494)
2010-08-09
15:45
[60ba166a82] part of check-in [d9e242f92a] Fix a bunch of documentation typos reported on the mailing list. (check-in: [d9e242f92a] user: drh branch: trunk, size: 38401)
2010-07-23
01:13
[67a517b8f6] part of check-in [06b1be36db] Updates to the optimizer documentation. (check-in: [06b1be36db] user: drh branch: trunk, size: 38408)
2010-04-12
13:57
[2e73d3391b] part of check-in [906016ee92] Add initial automatic indexing documentation. (check-in: [906016ee92] user: drh branch: trunk, size: 38601)
2010-01-13
22:15
[86e758e706] part of check-in [ad70832674] Add fragments to headings of longer documents. (check-in: [ad70832674] user: drh branch: trunk, size: 36462)
2009-12-22
01:09
[5e76de7d85] part of check-in [10b7c35b44] Add more requirements marks to the optoverview.html document. (check-in: [10b7c35b44] user: drh branch: trunk, size: 36445)
2009-10-22
17:53
[d23fd94dc9] part of check-in [687a957242] Updates to pragma and optimizer documents. Add the evidence formatter and make corresponding revisions to the tracability matrix generator. (check-in: [687a957242] user: drh branch: trunk, size: 36202)
2009-10-20
13:54
[36a257c812] part of check-in [0b4f64fd77] Updates to the optoverview.html document to explain the recent changes to the LIKE and GLOB operator and how they now might be optimized when their RHS is host parameter. (check-in: [0b4f64fd77] user: drh branch: trunk, size: 35841)
2009-10-17
08:25
[80fe0b6d90] part of check-in [15b96b6b0a] Add keywords to two sections in optoverview.in. So that documentation for sqlite3_reoptimize() can link to them. (check-in: [15b96b6b0a] user: dan branch: trunk, size: 34679)
2009-08-31
13:47
[30f40c53c0] part of check-in [d8db9f9b5c] Query planner documentation update. (check-in: [d8db9f9b5c] user: drh branch: trunk, size: 34608)
2009-08-22
02:53
[110d37fee1] part of check-in [ded8a7f88c] Updates to the query planner documentation. (check-in: [ded8a7f88c] user: drh branch: trunk, size: 30632)
2009-03-18
14:19
[517585322a] part of check-in [cfa4627882] Fix typos in documentation. This is the fix for ticket [9ed3b9626c9462e11a557621152f3e2d4eead482] (check-in: [cfa4627882] user: drh branch: trunk, size: 20412)
2009-01-02
17:36
[ed10da9236] part of check-in [0a327982e8] Updating documentation for version 3.6.8. (check-in: [0a327982e8] user: drh branch: trunk, size: 20408)
2008-12-15
22:49
[cc259f99a5] part of check-in [47171588ec] Attempt to do a better job of explaining INTEGER PRIMARY KEY. (check-in: [47171588ec] user: drh branch: trunk, size: 19309)
2008-09-22
12:42
[e60b6504d8] part of check-in [b46eae7d62] Add the observation that the unary "+" operator destroys type affinity. (check-in: [b46eae7d62] user: drh branch: trunk, size: 19305)
2007-12-20
03:29
[be90481399] part of check-in [16b1f03012] An attempt to get automatic hyperlinking working on all web pages. The website builds, but there are still many problems. (check-in: [16b1f03012] user: drh branch: trunk, size: 18777)
2007-11-13
15:38
[402536bc7b] part of check-in [006a5480c2] Miscellaneous small cleanups. Check-in prior to tackling the "News". (check-in: [006a5480c2] user: drh branch: trunk, size: 18786)
2007-11-12
15:32
Added: [b468ea60db] part of check-in [275febef8f] Complete reorganization of the documentation sources. (check-in: [275febef8f] user: drh branch: trunk, size: 18927)