> Can anyone recommend which method I should try first?
Don't create the auto increment pk, as it is unnecessary.
With MySQL the fastest is often:
Primary(a,b)
index(b)
And in sometimes you even want:
Primary(a,b)
index(a)
index(b)
I think mysql treats primary key pairs as a simple concatenat
I need a table that will be used basically as a map between records in
another table and I'm not sure how to create the indexes.
At first I thought I would just do something like:
CREATE TABLE map (
id int(5) unsigned NOT NULL AUTO_INCREMENT,
a int(5) unsigned NOT NULL,
b int(
