Some small legibility / continuity change suggestions to the new 
index_xinfo pragma doc:

Original:

*PRAGMA */database./*index_xinfo(*/index-name/*);*

This pragma returns information about every column in an index. Unlike 
this index_info pragma 
<http://www.sqlite.org/draft/pragma.html#pragma_index_info>, this pragma 
returns information about every column in the index, not just the key 
columns. (A key column is a column that is actually named in the CREATE 
INDEX <http://www.sqlite.org/draft/lang_createindex.html> index 
statement or UNIQUE constraint 
<http://www.sqlite.org/draft/lang_createtable.html#uniqueconst> or 
PRIMARY KEY constraint 
<http://www.sqlite.org/draft/lang_createtable.html#primkeyconst> that 
created the index. Auxiliary columns are additional columns needed to 
locate the table entry that corresponds to each index entry.)

Output columns from the index_xinfo pragma are as follows:

 1. The rank of the column within the index. (0 means left-most. Key
    columns come before auxiliary columns.)
 2. The rank of the column within the table being indexed, or -1 if the
    index-column is the rowid
    <http://www.sqlite.org/draft/lang_createtable.html#rowid> of the
    table being indexed.
 3. The name of the column being indexed, or NULL if the index-column is
    the rowid <http://www.sqlite.org/draft/lang_createtable.html#rowid>
    of the table being indexed.
 4. 1 if the index-column is sorted in reverse (DESC) order by the index
    and 0 otherwise.
 5. The name for the collating sequence
    <http://www.sqlite.org/draft/datatype3.html#collation> used to
    compare values in the index-column.
 6. 1 if the index-column is a key column and 0 if the index-column is
    an auxiliary column


Suggested  (changes in *...*):

*PRAGMA */database./*index_xinfo(*/index-name/*);*

This pragma returns information about every column in an index. Unlike 
*the* index_info pragma 
<http://www.sqlite.org/draft/pragma.html#pragma_index_info>, this pragma 
returns information about *all columns used* in the index *and not only* 
the key columns. (A key column is a column that is actually named in 
*the CREATE INDEX <http://www.sqlite.org/draft/lang_createindex.html>, 
UNIQUE constraint 
<http://www.sqlite.org/draft/lang_createtable.html#uniqueconst> or 
PRIMARY KEY constraint 
<http://www.sqlite.org/draft/lang_createtable.html#primkeyconst> 
statement which created the index*. Auxiliary columns are additional 
columns needed to locate the table entry that corresponds to each index 
entry.)

Output columns from the index_xinfo pragma are as follows:

 1. The rank of the column within the index. (0 means left-most. Key
    columns come before auxiliary columns.)
 2. The rank of the column within *the table, or -1 if the column is the
    rowid <http://www.sqlite.org/draft/lang_createtable.html#rowid> of
    the table being indexed*.
 3. The name of the column being indexed, or NULL *if the column is the
    rowid <http://www.sqlite.org/draft/lang_createtable.html#rowid> of
    the table being indexed*.
 4. 1 if the *column is sorted in reverse order (DESC) in the index, or*
    0 otherwise.
 5. The name for the collating sequence
    <http://www.sqlite.org/draft/datatype3.html#collation> used to
    compare values in the index-column.
 6. 1 if the *column is a key column, or 0 if it is an auxiliary column*.





Reply via email to