Documentation Source Text

All files named "pages/queryplanner-ng.in"
Login

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

History for pages/queryplanner-ng.in

2024-05-10
14:30
[bc3a55d001] part of check-in [780800b996] Fix a hyperlink broken by the previous merge. (check-in: [780800b996] user: drh branch: branch-3.45, size: 37610)
14:15
[d2ca5c644c] part of check-in [9316ff2178] A few more tweaks to query planner documentation. (check-in: [9316ff2178] user: drh branch: trunk, size: 37656)
11:16
[5a4e8a8707] 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: 37494)
2024-03-18
23:31
[6c97714b0b] part of check-in [8daf6750f4] Improvements to query planner documentation. (check-in: [8daf6750f4] user: drh branch: trunk, size: 37493)
2024-02-16
18:43
[f8ade73069] part of check-in [da19a9e007] New hyperlinks and refinements to the enhanced ANALYZE documentation. (check-in: [da19a9e007] user: drh branch: trunk, size: 37404)
18:31
[3932ba153d] part of check-in [b101c6c0fb] Clarify and expand the documentation on the use of PRAGMA optimize and ANALYZE and the query planner stability guarantee. (check-in: [b101c6c0fb] user: drh branch: trunk, size: 37310)
2024-01-31
23:45
[8b0a417d78] part of check-in [9de0929942] Cure a few grammatical flaws reported in the forum, and zap trailing whitespace. (check-in: [9de0929942] user: larrybr branch: trunk, size: 37327)
2023-10-06
10:46
[e1aa632a3e] part of check-in [57bf6c4ae7] Global replace http://www.sqlite.org with https://www.sqlite.org in pages/*.in. (check-in: [57bf6c4ae7] user: stephan branch: trunk, size: 37401)
2022-09-19
12:27
[0789a542ae] part of check-in [1ddadab8ef] Minor tweaks to query optimizer documentation. (check-in: [1ddadab8ef] user: drh branch: trunk, size: 37399)
2021-06-11
16:58
[684d53df3f] part of check-in [5a0eb23b3e] Update the built-in Pikchr formatter to the latest version that includes support for alternative spellings for "<-" and "->" tokens. Make use of this new feature to omit "<" characters from embedded Pikchr text on documentation pages. (check-in: [5a0eb23b3e] user: drh branch: trunk, size: 37396)
2021-06-10
19:09
[129256173a] part of check-in [31f540fa7a] Add new text to queryplanner-ng.html to talk about the newer and better approach to query optimization in Fossil using PRAGMA optimize. (check-in: [31f540fa7a] user: drh branch: trunk, size: 37364)
18:46
[aa8bfb8206] part of check-in [7684d973c9] Also convert the second diagram in queryplanner-ng.html into Pikchr. (check-in: [7684d973c9] user: drh branch: trunk, size: 35737)
17:28
[a062704b15] part of check-in [e484b8b83a] Convert the TPC-H Q8 diagram from a GIF into PIKCHR. (check-in: [e484b8b83a] user: drh branch: trunk, size: 34368)
2020-06-18
21:18
[ef450fb220] part of check-in [e01d8c6144] Terminology adjustments. (check-in: [e01d8c6144] user: drh branch: trunk, size: 32837)
2018-11-24
20:24
[e4ffb2f572] part of check-in [9e12c649c9] Minor enhancements and updates to various documents. (check-in: [9e12c649c9] user: drh branch: trunk, size: 32837)
2018-06-08
13:21
[778c553c17] part of check-in [59e5f9e3da] Use https for all internal hyperlinks. (check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 32434)
2017-06-29
14:53
[72e87208eb] part of check-in [fa4e2ba5b2] Updates to the query planner stability guarantee description to make it clear that it is off by default. (check-in: [fa4e2ba5b2] user: drh branch: trunk, size: 32431)
2016-09-21
13:34
[a0d7f3aefc] part of check-in [79dd9ff1e4] Query planner tutorial updates. (check-in: [79dd9ff1e4] user: drh branch: trunk, size: 32372)
2016-09-14
18:40
[6dac626fd8] 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: 32362)
2016-08-29
18:38
[371166234a] part of check-in [e4c2e46a8c] Merge "experimental" with this branch. Adds more links to the front page, fts5 search, show/hide links for tables of contents and some other things. (check-in: [e4c2e46a8c] user: dan branch: trunk, size: 32340)
16:07
[1c500a871a] part of check-in [5baf5a5191] Improvements to the opcode.html page. Minor tweaks to legacy c_interface.html and queryplanner-ng.html (check-in: [5baf5a5191] user: drh branch: trunk, size: 32419)
2016-08-25
12:18
[fbd581abc1] part of check-in [066e5931ce] Add <fancy_format> or <table_of_contents> markup to a few more documents. To ensure that there are enough anchors in the longer documents for the search script to use. (check-in: [066e5931ce] user: dan branch: experimental, size: 32324)
2014-07-02
16:24
[c102f3d7bc] part of check-in [8471968fb0] Fix some typos in queryplanner-ng.in. (check-in: [8471968fb0] user: dan branch: trunk, size: 32403)
2014-02-28
12:26
[5fcac0dd65] part of check-in [e139253c4b] Minor clarifications of recent documentation. (check-in: [e139253c4b] user: drh branch: trunk, size: 32397)
2013-11-18
18:48
[7e16d6dcad] 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: 32396)
2013-10-19
16:21
[445b06f216] 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: 32396)
2013-08-30
14:28
[8a253bf37a] part of check-in [4e286cee85] Added a 3.8.1 change log. Added documentation on SQLITE_MINIMUM_FILE_DESCRIPTOR. (check-in: [4e286cee85] user: drh branch: trunk, size: 31905)
14:03
[9f1cb3454e] part of check-in [3f23dd6ba9] Include all changes since 3.7.17 in the 3.8.0.1 change log. Typos fixed in the NGQP document. (check-in: [3f23dd6ba9] user: drh branch: branch-3.8.0, size: 31876)
2013-08-28
14:13
[7313344fcf] part of check-in [04ab4fa5ec] Add documentation for STAT4. (check-in: [04ab4fa5ec] user: drh branch: trunk, size: 31909)
2013-08-27
13:34
[82ef546c85] part of check-in [9747293881] Fix typos in the queryplanner-ng document. (check-in: [9747293881] user: drh branch: trunk, size: 31880)
2013-08-23
16:37
[58a4d51b17] part of check-in [a5a0ee107d] Clarification and typo fixes in the NGQP document. (check-in: [a5a0ee107d] user: drh branch: trunk, size: 31879)
16:16
[b45b9a9689] part of check-in [ce2a4ec1e7] Fix documentation typos. (check-in: [ce2a4ec1e7] user: drh branch: trunk, size: 31882)
2013-08-07
00:21
[821e774052] part of check-in [5cbddcc945] Clarifications and typo-fixes in the NGQP document. (check-in: [5cbddcc945] user: drh branch: trunk, size: 31886)
2013-07-17
00:17
[e855795530] part of check-in [232b584bda] Tweaks to the text describing the hazards of upgrading to the NGQP. (check-in: [232b584bda] user: drh branch: trunk, size: 31950)
2013-07-01
16:07
[0070c5b46a] 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: 30914)
2013-06-26
14:35
[d7eebc59f9] part of check-in [e0c107dec3] Updates to the changes.html page. Fix typos on the NGQP documentation. (check-in: [e0c107dec3] user: drh branch: trunk, size: 29935)
2013-06-25
16:31
[829fd8f0c4] part of check-in [828ca81aae] Further improvement and expansion of the NGQP documentation, including adding a checklist for preventing and dealing with bad choices by the query planner. (check-in: [828ca81aae] user: drh branch: trunk, size: 29935)
01:44
[af8ff73644] part of check-in [e09abae6c3] Second draft of the NGQP document. (check-in: [e09abae6c3] user: drh branch: trunk, size: 24695)
2013-06-24
19:23
[1237e9536a] part of check-in [e1646aea15] Work toward documenting the NGQP changes. (check-in: [e1646aea15] user: drh branch: trunk, size: 24371)
2013-05-18
17:45
[dce3df7606] part of check-in [67d025e82c] Documentation updates for version 3.7.17. (check-in: [67d025e82c] user: drh branch: trunk, size: 9680)
2013-05-01
11:02
[7b45320ca7] part of check-in [c9e2b500a2] Fix typos in queryplanner-ng.html. (check-in: [c9e2b500a2] user: drh branch: trunk, size: 9906)
2013-04-30
22:20
[d6ad066281] part of check-in [28554e7596] Updates to the next-generation-query-planner document. (check-in: [28554e7596] user: drh branch: trunk, size: 9906)
16:49
Added: [db5bd562c4] part of check-in [74fbc7b392] Add the Next Generation Query Planner document. (check-in: [74fbc7b392] user: drh branch: trunk, size: 9403)