Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2004 @ 08:23:33 GMT


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


Subj:   Re: Best advice on PPIs
 
From:   Andy.McCann

We haven't spotted any performance reasons to not create as much forward or backward history as you see fit. The only issue comes around purging of data. As you probably know, you can drop partitions with delete and it is a very quick way to get rid of data on large tables. There are a number of limitations to this, especially if you have an unknown or no range partition and there were also a few bugs (3610s) that you would need to check out with your support rep. None of these are a big issue and can be worked around, just make sure you check out and test all the angles (as ever with the newer features) on query access and loading/maintenance processes before committing.


Cheers

Andy



     
  <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