Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 Jul 2007 @ 22:09:27 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Use of surrogate keys in place of dates
 
From:   Steve Hager

My intuition tells me that if I generate surrogate keys to substitute for actual dates in fact tables where I don't need special null handling, I will pay a heavy performance price in that my partitioning on the date column will be rendered ineffective. For example, I typically create my partitioning based on week since most queries involve such a time interval. If the partitioning scheme involved the surrogate key, I would not get rows for adjacent dates in the same partition because I could not partition by anything other than single SK values. Does the "dynamic partition elimination" feature eliminate this concern?



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016