I'm setting up indexes for a number of mysql tables. In some cases, these multi-column indexes (of type INDEX) include the primary key. For instance, in table Users, where pkey is UserID, I also have a two-column index on UserID and UserType (to accommodate queries that look at both these values).
phpMyAdmin is complaining that "Primary and Index keys should not both be set for column "UserID"
I'm wondering what I should do - do I leave UserID out and just index UserType (and assume that MySQL will use both indexes)? Or is phpMyAdmin wrong?
