All Forums Database
fishmo 1 post Joined 03/06
22 Mar 2006
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

TD_Arch 35 posts Joined 07/05
24 Mar 2006

You can considering partitioning your table on the data field.

You must sign in to leave a comment.