S
S
Sergey Pugovkin2016-04-13 14:12:21
PHP
Sergey Pugovkin, 2016-04-13 14:12:21

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

2 answer(s)
P
Peter, 2016-04-13
@Driver86

The PRIMARY KEY is always created through the creation of a UNIQUE INDEX. So you don't need to create an additional index.

I
Ivan Filatov, 2016-04-13
@NYMEZIDE

not necessary

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question