Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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.

OR

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,

Amit



     
  <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