SQLite Forum

Clustered vs Non Clustered Indexes in SQLite

Clustered vs Non Clustered Indexes in SQLite

(1) By anonymous on 2021-07-01 21:35:52 [source]

I am coming from SQL Server world . I have been researching to figure out how to create Clustered Index in SQLite on non-primary key columns ? Also , how to create Non-Clustered Index in SQLite on Primary Key columns ? It seems like SQLite doesn't support Clustered or Non Clustered keywords like It works in standard SQL engine.

(2) By Tim Streater (Clothears) on 2021-07-01 22:04:44 in reply to 1 [link] [source]

Perhaps, since SQLite is not a server-based engine, it doesn't matter. But since I don't know what you are talking about, I'll await input from those who do.

(3) By Richard Hipp (drh) on 2021-07-01 22:23:05 in reply to 1 [link] [source]

A Clustered-Index in SQL Server is the equivalent of the PRIMARY KEY on a WITHOUT ROWID table in SQLite. Or, if the PRIMARY KEY is just an integer, then it is the clustered index for the ordinary rowid table.