can anyone tell me if Sqlite supports clustered and nonclustered indexes? and if it does how do i make a column which is non primary key a nonclustered index? I am very new to database concepts hence very confused..
相关问题
- SQL/SQL-LITE - Counting records after filtering
- What SQLite NuGet package do I need
- How to write the array into the sqlite database fo
- Groupwise MAX() on a subquery
- metaData.getPrimaryKeys() returns a single row whe
In SQLite, indexes created with CREATE INDEX are non-clustered indexes.
Since version 3.8.2, SQLite supports WITHOUT ROWID tables, which are clustered indexes.