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