i have a table, it will store millions of rows, corresponding to raw byte sequences from many sources. I´m thinking on using for primary key two options:
1- Columns: (source_id, date, data) and PK = (source_id, date)
2- Columns: (id, date, data) and PK = (id)
The sources are, of course, entries in another table so source_id is FK.
Is there any inconvenience on using a date as part of the PK?
Thanks in advance