Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 10 Jan 2015 @ 18:06:47 GMT


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


Subj:   Re: Restructure large tracking table
 
From:   Myrna, James

Is the typical query looking for a month-end date BETWEEN the Effective_From_Date and Effective_To_Date? It sounds like you have a slowly changing table, and partitioning won't really help (you don't know the value for FROM or TO date), full table scans are the norm. But is this really slowly changing? Maybe a new table called month-end-snapshot could be created, which could be partitioned.


Jim



     
  <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: 23 Jun 2019