Does SQLite create indexes automatically?

Question

Does SQLite automatically create indexes when declaring a primary key? foreign key? Or do you need to create them manually?

Nicolas Chabanovsky ♦ Nicolas Chabanovsky 38.2k 54 222 438 · Accepted Answer · 2012-04-19T14:58:53

SQLite creates indexes automatically in some cases.

... both the UNIQUE and the PRIMARY KEY constraints are what the statement would be. The index is used to optimize queries ...

1 answer 1