Dates and Foreign Keys


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).


Re: Dates and Foreign Keys

You can considering partitioning your table on the data field.