Documentation Source Text
Check-in [d52ed0]
Not logged in

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

Overview
SHA1 Hash:d52ed00775903f2fac3ed60c49a4fa62227b947a
Date: 2013-05-14 11:12:10
User: drh
Comment:Fix a typo in queryplanner.html.
Tags And Properties
Context
2013-05-14
11:14
[d1d257] Fix another typo in queryplanner.in. (user: drh, tags: trunk)
11:12
[d52ed0] Fix a typo in queryplanner.html. (user: drh, tags: trunk)
02:37
[af7d79] Improved hyperlinks on various documents. (user: drh, tags: trunk)
Changes
Hide Diffs Unified Diffs 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