Dates and Foreign Keys

Database
Not applicable

Dates and Foreign Keys

What is the generally recognized approach when dealing with business dates (Order date, Ship date) where they'll be used in conjunction with a date dimension table (for adhoc queries)? More specifically, is there an advantage to defining a foreign key relationship to the date table for each business date type? Or, are there better alternatives available (join indexes, etc...)? My assumption is that I'll be using a date format for the key (not a surrogate key).

Thanks
1 REPLY
Enthusiast

Re: Dates and Foreign Keys

You can considering partitioning your table on the data field.