Alan Harris-Reid wrote:
> I have a table with a primary key field called artist_id, which is also
> marked as autoincrement. If I want an index on this field
You don't. There is already an index on this field. SQLite automatically
generates an index to enforce PRIMARY KEY and UNIQUE
I have a table with a primary key field called artist_id, which is also
marked as autoincrement. If I want an index on this field (eg. to
improve performance when joining with other tables), do I have to index
it explicitly, or does the fact that it is already an autoincrement pk
field
2 matches
Mail list logo