Does sqlite support indexes?

Question

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

http://stackoverflow.com/a/10147957/1864610 – Mar 27 '15 at 05:22 — , Mar 27 '15 at 05:22
@HoboSapiens That information is outdated. – CL. Mar 27 '15 at 08:20 — CL., Mar 27 '15 at 08:20

score 13 · Answer 1 · answered Mar 27 '15 at 08:19

13

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.

answered Mar 27 '15 at 08:19

CL.

173,858
17
217
259

Does sqlite support indexes?

1 Answers1

Linked

Related