Documentation Source Text

Check-in [d52ed00775]
Login

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: 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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/queryplanner.in.

   475    475   When no appropriate indices are available, a query with an ORDER BY
   476    476   clause must be sorted as a separate step.  Consider this query:
   477    477   </p>
   478    478   
   479    479   <tcl>code {SELECT * FROM fruitsforsale ORDER BY fruit;}</tcl>
   480    480   
   481    481   <p>
   482         -SQLite processes this by gather all the output of query and then
          482  +SQLite processes this by gathering all the output of query and then
   483    483   running that output through a sorter.
   484    484   </p>
   485    485   
   486    486   <tcl>figure 16 #fig16 obfruitnoidx.gif {Sorting Without An Index}</tcl>
   487    487   
   488    488   <p>
   489    489   If the number of output rows is K, then the time needed to sort is