I've always set the first column (the "id" equivalent that I use for JOIN queries) to auto_increment and set it as the primary key. Reading MySQL's documentation there are several types of indexes to use: PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT. In general is primary key the way to go and if not what contexts apply for each type please?
- John