Does sqlite support indexes? [closed]

问题:

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..

回答1:

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.