Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 04 Apr 2007 @ 19:15:12 GMT


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


Subj:   Re: Summarizing dbc.qrylog table
 
From:   Diehl, Robert

Eric,

Well put. However, I suggest that you only keep a couple of days in the dbc tables except for summary tables. There are two reasons:

1) query performance will not be as good against the DBC tables as they will not have the PPI, secondary indexes or join indexes that you may add.

2) You cannot backup these DBC tables. In the event you have a catastrophic problem and have to rebuild the whole system you will loose the information in the DBQL log tables. NOTE: THIS would be really rare, but you might want to plan for it.


Thanks,

Bob Diehl



     
  <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: 28 Jun 2020