Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 10 May 2006 @ 10:04:56 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Help me in finding answers for few questions
From:   Singh, Amit

Hi all,

Can anyone help me in giving there opinion from their experience for the following questions:

1) How partitioning a big table can help improving the performance in Teradata?

2) What is the best practice for managing a huge table? Should we split one big table into multiple tables (on the basis of one attribute, for e.g. Year) & use the latest table to answer the query.


We can hold all of the history data in one big table & use one table to hold the latest data. For example to store the data for last 5 years in one table & for current year we can use one table.

3) What is the best practice in using Staging server? Should we use multiple small staging servers for Extraction & Transformation or should we use one big server to handle everything? Which one can be easily managed?

If anything here is not clearly understood please revert back.

Thanks & Regards,


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020