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

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)