Answer the question
In order to leave comments, you need to log in
SQLite: Do I need to create an index on primary key autoincrement field?
SQLite.
There is a field: id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
Do I need to create an index?CREATE UNIQUE INDEX c_id ON categories (id)
Answer the question
In order to leave comments, you need to log in
The PRIMARY KEY is always created through the creation of a UNIQUE INDEX. So you don't need to create an additional index.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question