ARJUN ARJUN - 5 months ago 45
SQL Question

is date is good candidate for clustred index key

is date column is good for clustred index key

Answer

date can be a good primary key for clustered index, but in general scenario, we don't link many tables (foreign key) using date.

i think it is depend on your er-diagram.