Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Jul 2002 @ 08:06:05 GMT


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


Subj:   Re: Archiving Resusage Tables
 
From:   David Wellman

Keeping a separate copy of ResUsage tables also has other advantages...

-- you can add SI's as required (value ordered NUSI on THEDATE?)

-- you can make them NO FALLBACK to save disk space

-- you can reduce the size of the real ResUsage tables in DBC so making queries against these faster

-- and probably others.

(as you can probably tell !) I'm a big fan of doing this.

There's also no reason why you shouldn't take the same approach with some other DBC tables which also build up history.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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: 15 Jun 2023