Documentation Source Text

File History
Login

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

History of pages/optoverview.in

2018-11-24
20:24
Minor enhancements and updates to various documents. file: [78717d462e] check-in: [9e12c649c9] user: drh branch: trunk, size: 57034
2018-05-31
19:14
Typo fixes. file: [655f8eaaf1] check-in: [db85f0efae] user: drh branch: trunk, size: 57020
2018-04-12
17:04
Fix a typo on the optoverview.html document. file: [954b3bdc70] check-in: [5272d8d61d] user: drh branch: trunk, size: 57021
2018-03-30
17:15
Fix a close-requirement mark in optoverview.html. file: [154fbdc63c] check-in: [2f6a562725] user: drh branch: trunk, size: 57021
2018-03-23
14:53
Clarification of text in the new optoverview.html section on the LEFT JOIN Optimization. file: [19e17d4225] check-in: [9e6750c1fc] user: drh branch: trunk, size: 57020
11:47
Fix typos. Clarification to the CoC in response to criticism. file: [194270f888] check-in: [79f3efbc86] user: drh branch: trunk, size: 57027
2018-03-22
18:55
Further enhancement to the optimizer overview document, giving the change log for 3.23.0 something to link to. file: [2a6452a491] check-in: [219fa13637] user: drh branch: trunk, size: 57026
13:36
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. file: [ff454b22aa] check-in: [69fd8c5ba9] user: drh branch: trunk, size: 52306
2018-02-01
14:43
Fix a typo in the flattening rules of the optoverview.html document. file: [89e702770e] check-in: [20ecb45b42] user: drh branch: branch-3.22, size: 53198
2018-01-26
15:50
Turn on "fancy-format" for the optoverview.html document. file: [0ee7cdbe02] check-in: [98e66068fe] user: drh branch: trunk, size: 53202
15:44
Bring the query flattening section of the optoverview.html document up to date with version 3.22.0. file: [92ad6238c9] check-in: [a599e76d95] user: drh branch: trunk, size: 53224
2017-10-04
16:16
In the co-routine documentation, mention that future versions of SQLite might make smarter transformations. file: [ec59257d09] check-in: [9cf55de770] user: drh branch: trunk, size: 52349
15:53
Improvements to the co-routine documentation. file: [0bfbd93c29] check-in: [18d1ad0854] user: drh branch: trunk, size: 51954
2017-10-02
03:42
Mention changes to the use of co-routines in the change log. Provide information on co-routines in the query planner overview document. file: [415b6523c1] check-in: [7e35a79626] user: drh branch: trunk, size: 50668
2017-08-03
20:39
Begin a change log entry for the 3.21.0 release. file: [5530c6137d] check-in: [4cadcc5b9c] user: drh branch: trunk, size: 48198
2017-06-29
18:17
Add documentation for the STMT virtual table file: [0eda4b542e] check-in: [3c1197562c] user: drh branch: trunk, size: 48224
2017-04-18
11:52
Update to the flattening optimization description in the optoverview.html page. Add a new bullet to the change log for 3.19.0. file: [3909efd58f] check-in: [d26b238e7e] user: drh branch: trunk, size: 48202
2017-03-15
20:51
Update the details of when the LIKE optimization is allowed, due to enhancements to the LIKE optimization logic in 3.18.0. file: [c4d63ac5a5] check-in: [7c122e0975] user: drh branch: trunk, size: 48162
2016-10-31
13:19
Additional cross-referencing of query planner documents. file: [6f89f2bfd1] check-in: [e5277d7908] user: drh branch: trunk, size: 47574
2016-09-14
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. file: [7d14f646cb] check-in: [858d993381] user: drh branch: trunk, size: 47471
2015-11-02
14:10
Add a note to help clarify that automatic indexes and internal indexes used to implement PRIMARY KEY and UNIQUE constraints are unrelated. file: [d24cee4073] check-in: [6910bdfa2a] user: drh branch: trunk, size: 47452
2015-10-07
19:40
Link the optoverview.html document to the new expridx.html document. file: [b4a057ccaa] check-in: [47d33de042] user: drh branch: trunk, size: 46770
2015-07-23
22:05
Improvements to the change log. file: [498b05633f] check-in: [12a7bb44f4] user: drh branch: trunk, size: 46494
2015-07-13
22:07
First cut at OTA documentation. file: [dd10fc5b35] check-in: [a5dfd4a26b] user: drh branch: trunk, size: 46476
2015-01-07
12:53
Write ESCAPE instead of EXCEPT as the modifier for the LIKE operator. file: [703014936f] check-in: [1e0e7c9300] user: drh branch: trunk, size: 46615
2014-08-14
13:06
Fix typos. file: [b4dd7207d5] check-in: [09088d9a21] user: drh branch: trunk, size: 46615
2014-05-25
20:08
Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. file: [3a9c8e70ca] check-in: [fc0e9baa66] user: drh branch: trunk, size: 46619
2013-11-27
04:26
Update the skip-scan documentation to mention the magic 18 number for when skip-scan becomes profitable. file: [d4c21a1f2d] check-in: [3eaa7f572e] user: drh branch: trunk, size: 45342
2013-11-18
18:48
Fix documentation typos pointed out on the mailing list by Philip Newton. file: [ff4ea75ff5] check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 45244
2013-11-13
22:39
Update the change log to show the skip-scan optimization and other recent changes. Add documentation on skip-scan. file: [bffb181541] check-in: [9b1dc53b75] user: drh branch: trunk, size: 45244
2013-10-19
16:21
Updates to documentation for recent changes, especially the unlikely() function and STAT4. Also fix some typos. file: [8de0e412c9] check-in: [0998ee24a4] user: drh branch: trunk, size: 41174
2013-08-28
14:13
Add documentation for STAT4. file: [ad059797c1] check-in: [04ab4fa5ec] user: drh branch: trunk, size: 41176
2013-08-23
16:16
Fix documentation typos. file: [b204ac5efa] check-in: [ce2a4ec1e7] user: drh branch: trunk, size: 40846
2013-07-01
16:07
Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. file: [afb4bd113f] check-in: [641e107a66] user: drh branch: trunk, size: 40846
2011-12-30
14:57
Major speed improvement on the script that translates requirements. Fix requirements markup in optoverview.html and in fileformat2.html. Fixes to requirements.html. file: [885eed68fe] check-in: [986229bc47] user: drh branch: trunk, size: 38495
2011-10-07
23:26
Update documentation for SQLITE_ENABLE_STAT3. file: [b456f0f719] check-in: [4b78e06344] user: drh branch: trunk, size: 38495
2011-06-20
21:48
Documentation typos. file: [a2b0c9e324] check-in: [b503d1f516] user: drh branch: trunk, size: 38495
2010-11-10
18:43
Add some more documentation for EXPLAIN QUERY PLAN. file: [430c621966] check-in: [37f6e9f261] user: dan branch: trunk, size: 38494
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [60ba166a82] check-in: [d9e242f92a] user: drh branch: trunk, size: 38401
2010-07-23
01:13
Updates to the optimizer documentation. file: [67a517b8f6] check-in: [06b1be36db] user: drh branch: trunk, size: 38408
2010-04-12
13:57
Add initial automatic indexing documentation. file: [2e73d3391b] check-in: [906016ee92] user: drh branch: trunk, size: 38601
2010-01-13
22:15
Add fragments to headings of longer documents. file: [86e758e706] check-in: [ad70832674] user: drh branch: trunk, size: 36462
2009-12-22
01:09
Add more requirements marks to the optoverview.html document. file: [5e76de7d85] check-in: [10b7c35b44] user: drh branch: trunk, size: 36445
2009-10-22
17:53
Updates to pragma and optimizer documents. Add the evidence formatter and make corresponding revisions to the tracability matrix generator. file: [d23fd94dc9] check-in: [687a957242] user: drh branch: trunk, size: 36202
2009-10-20
13:54
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. file: [36a257c812] check-in: [0b4f64fd77] user: drh branch: trunk, size: 35841
2009-10-17
08:25
Add keywords to two sections in optoverview.in. So that documentation for sqlite3_reoptimize() can link to them. file: [80fe0b6d90] check-in: [15b96b6b0a] user: dan branch: trunk, size: 34679
2009-08-31
13:47
Query planner documentation update. file: [30f40c53c0] check-in: [d8db9f9b5c] user: drh branch: trunk, size: 34608
2009-08-22
02:53
Updates to the query planner documentation. file: [110d37fee1] check-in: [ded8a7f88c] user: drh branch: trunk, size: 30632
2009-03-18
14:19
Fix typos in documentation. This is the fix for ticket [9ed3b9626c9462e11a557621152f3e2d4eead482] file: [517585322a] check-in: [cfa4627882] user: drh branch: trunk, size: 20412
2009-01-02
17:36
Updating documentation for version 3.6.8. file: [ed10da9236] check-in: [0a327982e8] user: drh branch: trunk, size: 20408
2008-12-15
22:49
Attempt to do a better job of explaining INTEGER PRIMARY KEY. file: [cc259f99a5] check-in: [47171588ec] user: drh branch: trunk, size: 19309
2008-09-22
12:42
Add the observation that the unary "+" operator destroys type affinity. file: [e60b6504d8] check-in: [b46eae7d62] user: drh branch: trunk, size: 19305
2007-12-20
03:29
An attempt to get automatic hyperlinking working on all web pages. The website builds, but there are still many problems. file: [be90481399] check-in: [16b1f03012] user: drh branch: trunk, size: 18777
2007-11-13
15:38
Miscellaneous small cleanups. Check-in prior to tackling the "News". file: [402536bc7b] check-in: [006a5480c2] user: drh branch: trunk, size: 18786
2007-11-12
15:32
Complete reorganization of the documentation sources. file: [b468ea60db] check-in: [275febef8f] user: drh branch: trunk, size: 18927 Added