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