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: | d52ed00775903f2fac3ed60c49a4fa62 |
| User & Date: | drh 2013-05-14 11:12:10 |
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
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
|