Re:SQLite's Automatic Indexes
by masklinn on Wednesday December 28, 2022 @03:49PM
(#34165782)
> This is not true in my experience at all. You have to create indexes.
Nobody said you don’t have to create other indexes.
> Also, a btree is created for rowid, according to these docs.
As the GP says that btree is the table itself, that’s what a clustered table is.
This is the bit that reveal this information:
> As an ordinary SQLite table, "wordcount" is implemented as two separate B-Trees. The main table uses the hidden rowid value as the key and stores the "word" and "cnt" columns as data.
So one of the btrees is “the main table”, of which rowid is the key.
Nobody said you don’t have to create other indexes.
> Also, a btree is created for rowid, according to these docs.
As the GP says that btree is the table itself, that’s what a clustered table is.
This is the bit that reveal this information:
> As an ordinary SQLite table, "wordcount" is implemented as two separate B-Trees. The main table uses the hidden rowid value as the key and stores the "word" and "cnt" columns as data.
So one of the btrees is “the main table”, of which rowid is the key.