I have a log table that captures the datetime stamp of when certain files were exported to another system.
The exportedLog table currently has three fields:
id (primary key) messageId (int) exportedDateTime (datetime)
Reviewing this I found that the
id field serves no purpose, as there are no joins to this table.
The only thing working on this table is the insert of the batch job that processes the messages and inserts into this log table.
Should I remove the
Should I have a primary key on either
exportedDateTime or both?