Does SQLite automatically create indexes when declaring a primary key? foreign key? Or do you need to create them manually?
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 ...