SQLite Forum

Clustered vs Non Clustered Indexes in SQLite
Login
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.