Trey Mack <[EMAIL PROTECTED]>
wrote:
Enough words.. concrete example:
CREATE TABLE t (id INTEGER PRIMARY KEY AUTOINCREMENT, a TEXT, b TEXT,
c TEXT);
CREATE INDEX i1 ON t (a); -- is this sufficient?
CREATE INDEX i2 ON t (a, id); -- or is this necessary to avoid going
back to the original table?
Every index automatically includes the ROWID of the table - that's how
SQLite links from the index entry to the corresponding table row. You
don't need to explicitly include the id in the index.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
