Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 03 Aug 2015 @ 19:45:17 GMT

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

Subj:   Re: NoPI tables as Staging tables
From:   Walter, Todd

Taimur Khan wrote:

  If there is an upgrade lets suppose moving from 100 amps to 200 amps up gradation. The data will still scattered on 100 amps even after upgradation to 200 amps.  

  Solution: Choose index for the tables and then restore it on the 200 amps and then make it NOPI : )  

If it is a staging table that is being emptied for each load cycle, then it is not required to do anything with the table. The next load into the table will populate all available AMPs.

If the table is permanent, small and NOPI, then it isn't harmful to let it just live on a subset of the AMPs.

Only if it is a large permanent table would it be advisable to take some steps to cause it to be redistributed to all AMPs. Note that there is a HASH BY option on INSERT SELECT which can be used to copy to a new table and distribute the data across all-AMPs.

  <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: 24 Jul 2020