Archives of the TeradataForum

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

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

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>>