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: |
d52ed00775903f2fac3ed60c49a4fa62 |
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
Changes to pages/queryplanner.in.
︙ | ︙ | |||
475 476 477 478 479 480 481 | 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> | | | 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 |
︙ | ︙ |