Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Turn on "fancy-format" for the optoverview.html document. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
98e66068fe499095018ede2452a691ad |
User & Date: | drh 2018-01-26 15:50:32.698 |
Context
2018-01-31
| ||
02:52 | Typo in the how-to-corrupt document. (check-in: 6ad1abb448 user: drh tags: branch-3.22) | |
2018-01-26
| ||
18:38 | Update documentation for CAST to integer to describe what happens when the integer is too large. This behavior is only supported on the latest trunk, so with this check-in the documentation is no longer suitable for use with 3.22.0. (check-in: 6b1b360098 user: drh tags: trunk) | |
15:50 | Turn on "fancy-format" for the optoverview.html document. (check-in: 98e66068fe user: drh tags: trunk) | |
15:44 | Bring the query flattening section of the optoverview.html document up to date with version 3.22.0. (check-in: a599e76d95 user: drh tags: trunk) | |
Changes
Changes to pages/optoverview.in.
1 2 3 4 5 6 7 8 9 10 | <title>The SQLite Query Optimizer Overview</title> <tcl>hd_keywords {optimizer} {query planner} {SQLite query planner}</tcl> <tcl> proc SYNTAX {text} { hd_puts "<blockquote><pre>" set t2 [string map {& & < < > >} $text] regsub -all "/(\[^\n/\]+)/" $t2 {</b><i>\1</i><b>} t3 hd_puts "<b>$t3</b>" hd_puts "</pre></blockquote>" | > > | 1 2 3 4 5 6 7 8 9 10 11 12 | <title>The SQLite Query Optimizer Overview</title> <tcl>hd_keywords {optimizer} {query planner} {SQLite query planner}</tcl> <fancy_format> <tcl> proc SYNTAX {text} { hd_puts "<blockquote><pre>" set t2 [string map {& & < < > >} $text] regsub -all "/(\[^\n/\]+)/" $t2 {</b><i>\1</i><b>} t3 hd_puts "<b>$t3</b>" hd_puts "</pre></blockquote>" |
︙ | ︙ | |||
39 40 41 42 43 44 45 | if {$n==1} { hd_puts "<h$n align='center'>$num $name</h$n>" } else { hd_puts "<h$n>$num $name</h$n>" } } | < < | 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | if {$n==1} { hd_puts "<h$n align='center'>$num $name</h$n>" } else { hd_puts "<h$n>$num $name</h$n>" } } PARAGRAPH { This document provides overview of how the query planner and optimizer for SQLite works. } PARAGRAPH { Given a single SQL statement, there might be dozens, hundreds, or even |
︙ | ︙ |