Documentation Source Text

Check-in [d52ed00775]
Login

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

Overview
Comment:Fix a typo in queryplanner.html.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d52ed00775903f2fac3ed60c49a4fa62227b947a
User & Date: drh 2013-05-14 11:12:10.355
Context
2013-05-14
11:14
Fix another typo in queryplanner.in. (check-in: d1d2571bce user: drh tags: trunk)
11:12
Fix a typo in queryplanner.html. (check-in: d52ed00775 user: drh tags: trunk)
02:37
Improved hyperlinks on various documents. (check-in: af7d790e13 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/queryplanner.in.
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
When no appropriate indices are available, a query with an ORDER BY
clause must be sorted as a separate step.  Consider this query:
</p>

<tcl>code {SELECT * FROM fruitsforsale ORDER BY fruit;}</tcl>

<p>
SQLite processes this by gather all the output of query and then
running that output through a sorter.
</p>

<tcl>figure 16 #fig16 obfruitnoidx.gif {Sorting Without An Index}</tcl>

<p>
If the number of output rows is K, then the time needed to sort is







|







475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
When no appropriate indices are available, a query with an ORDER BY
clause must be sorted as a separate step.  Consider this query:
</p>

<tcl>code {SELECT * FROM fruitsforsale ORDER BY fruit;}</tcl>

<p>
SQLite processes this by gathering all the output of query and then
running that output through a sorter.
</p>

<tcl>figure 16 #fig16 obfruitnoidx.gif {Sorting Without An Index}</tcl>

<p>
If the number of output rows is K, then the time needed to sort is