Actually, padders, since the MyLINKS table is an intersection relation between USERS and LINKS, you do not need the primary key of ID.
You would only need USERID (Index, NOT UNIQUE), LINKID (Index, UNIQUE), COMMENTS (UNIQUE)
This also creates a secondary index, which speeds up data processing.
Regards,
Eliot Lee
You would only need USERID (Index, NOT UNIQUE), LINKID (Index, UNIQUE), COMMENTS (UNIQUE)
This also creates a secondary index, which speeds up data processing.
Regards,
Eliot Lee