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 already take care of the index?
Any help would be appreciated. Alan Harris-Reid _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users