Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix another typo in queryplanner.in. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | d1d2571bcef53d1791f3d2490ddf7487 |
| User & Date: | drh 2013-05-14 11:14:12 |
Context
|
2013-05-15
| ||
| 18:58 | Add recent bug fixes to the 3.7.17 change log. check-in: 2b8ea61f51 user: drh tags: trunk | |
|
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 | |
Changes
Changes to pages/queryplanner.in.
315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 |
<p> A multi-column index follows the same pattern as a single-column index; the indexed columns are added in front of the rowid. The only difference is that now multiple columns are added. The left-most column is the primary key used for ordering the rows in the index. The second column is used to break ties in the left-most column. If there were a third column, it would be used to break ties for the first to columns. And so forth for as many columns as their are in the index. Because rowid is guaranteed to be unique, every row of the index will be unique even if all of the content columns for two rows are the same. That case does not happen in our sample data, but there is one case (fruit='Orange') where there is a tie on the first column which must be broken by the second column. </p> |
| |
315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 |
<p>
A multi-column index follows the same pattern as a single-column index;
the indexed columns are added in front of the rowid. The only difference
is that now multiple columns are added. The left-most column is the
primary key used for ordering the rows in the index. The second column is
used to break ties in the left-most column. If there were a third column,
it would be used to break ties for the first two columns. And so forth for
as many columns as their are in the index. Because rowid is guaranteed
to be unique, every row of the index will be unique even if all of the
content columns for two rows are the same. That case does not happen
in our sample data, but there is one case (fruit='Orange') where there
is a tie on the first column which must be broken by the second column.
</p>
|