Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Nov 2012 @ 22:24:18 GMT


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


Subj:   Adding Compression - Redistributing data
 
From:   Anomy Anom

< -- Anonymously Posted: Tuesday, November 06, 2012 16:26 -- >

I am adding compression to the table and was surprised to looking at the explain plan. It says the data is being redistributed. Everything is same in both the tables except that the second table is having compression. Any idea why?

     Insert into test1.STAGE_TBL
     Sel * from test.STAGE_TBL;

     First, lock test1.CHAR(34)pseudo tableCHAR(34) for write on a row hash.

     Next, we lock test.CHAR(34)pseudo tableCHAR(34) for read on a row hash.

     We lock test1.STAGE_TBL for write and we lock test.STAGE_TBL for read.

     We do an All-AMPs RETRIEVE step from test.STAGE_TBL by way of an all-rows
     scan into Spool 8211, which is redistributed by hash code to all AMPs.

     We do a MERGE into table STAGE_TBL from Spool 8211.

     We Spoil the parser's dictionary cache for the table.

     We send out an END TRANSACTION step to all AMPs involved in processing the
     request.

Thanks.



     
  <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