Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 25 Jan 2003 @ 11:11:40 GMT


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


Subj:   Re: Data Retention of System Log Tables
 
From:   David Wellman

Paul,

Probably every site does this (or something like it) so code should be easily available. Yes, Teradata Manager includes a 'system maintenance' application, I don't know if you can schedule the processes from here or would have to set them up manually.

Good idea to copy the data to historic tables, you can then change the table definitions as required to make life a lot 'better' when querying the data. You can remove fallback (halves your disk space requirement), add SI's, collect stats, compress columns, not copy all the columns -- in short all the things you might do with a normal user-defined table.


Cheers,

Dave



     
  <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