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) | |