Archives of the TeradataForum

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

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

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