Documentation Source Text
Check-in [d52ed00775903f2fac3ed60c49a4fa62227b947a]
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
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