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

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

Overview
Comment:Fix a typo in queryplanner.html.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:d52ed00775903f2fac3ed60c49a4fa62227b947a
User & Date: drh 2013-05-14 11:12:10
Context
2013-05-14
11:14
Fix another typo in queryplanner.in. check-in: d1d257 user: drh tags: trunk
11:12
Fix a typo in queryplanner.html. check-in: d52ed0 user: drh tags: trunk
02:37
Improved hyperlinks on various documents. check-in: af7d79 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