[sqlite] Re: use of ".indices"

[Igor Tandetnik]

Dixon Hutchinson
<sqlite-491LjFE5FnHkPponyUOvwgC/[EMAIL PROTECTED]> wrote:
Consider the sequence below with SQLite 3.3.7 on Windows:
   sqlite> CREATE TABLE xyzzy
      ...> (
      ...> comp TEXT,
      ...> parent INTEGER,
      ...> ROWID INTEGER PRIMARY KEY AUTOINCREMENT,
      ...> UNIQUE(parent, comp)
      ...> );
   sqlite> .indices xyzzy
   sqlite_autoindex_xyzzy_1
   sqlite>


Why doesn't the ".indices" command report two indices, one for the
ROWID, and one for the UNIQUE tuple of parent and comp?

ROWID does not require a separate standalone index. In SQLite, both 
tables and indices are implemented with the same B-tree structure. A 
table can be thought of as an index into itself - an index on ROWID. The 
table is physically organized so that rows are sorted by ROWID.

Igor Tandetnik 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------