Results 1 to 2 of 2
Thread: Join Table Index
Apr 22, 2011, 06:42 #1
- Join Date
- Feb 2006
- Atlanta, GA, USA
- 59 Post(s)
- 0 Thread(s)
Join Table Index
So here's another design question;
Should there be a defined index for a join table, if that index would have to be the entirity of the join table?
I have two axes of a matrix as the keys of the join table. This forms a many-to-many relationship between the two.
fk1,fk2 and data are not unique. (fk1,fk2) is not unique. Neither is (fk1,data) or (fk2,data). So the only index possible is (fk1,fk2,data), which is unique, but seems rather moot when the order of the data in the result query is not a factor and would result in the index being the entire table.
Am I missing anything here, oh great gurus of the databases?