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 constraints. > (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 already take care of the index? AUTOINCREMENT is irrelevant. Just PRIMARY KEY, with or without AUTOINCREMENT, results in the index being generated. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users