79241889

Date: 2024-12-01 15:32:34
Score: 2
Natty:
Report link

If you have n intermediate table without any other additional fields, go with composite key.

If the 'intermediate' table has additional fields, is not a trivial intermediate table. Then, having a surrogate key is better since indexing and quering for additional fields is more efficient.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: a8ana