Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Mar 2002 @ 09:00:27 GMT

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

Subj:   Re: Table partitioning
From:   Paul Johnson

I would look long and hard at your archive strategy before you go down the route of breaking tables into smaller chunks. This approach is very un-Teradata and will only increase your administration workload and query complexity in the long-run. Sites like Walmart and SBS have massive databases with several terabytes of data and I'd be very surprised if they indulge in breaking up tables to facilitate archiving. There are many ways to 'skin the cat' when it comes to archiving - this is where I'd focus your attention.

Paul Johnson.

  <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