Archives of the TeradataForum
Message Posted: Wed, 10 May 2006 @ 10:04:56 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|