Archives of the TeradataForum

Message Posted: Thu, 23 Sep 2004 @ 11:32:42 GMT

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

Hi,

Why is it that the following Queries have a significant difference in Execution Times ( I have around 90 Million Records in TEST_SKEW & System is a 2 Node - 20 AMP system )

1.  CREATE TABLE TEST_CREATE AS
     ( SELECT * FROM TEST_SKEW )
     WITH DATA PRIMARY INDEX ( MonthID ,MarketID ,MediaSubTypeID
                              ,BaseSegmentID ,CompanyID )

 2. INSERT INTO TEST_INSERT
     SELECT * FROM TEST_SKEW

           PI on TEST_INSERT  is ( MonthID ,MarketID ,MediaSubTypeID
                                  ,BaseSegmentID ,CompanyID )

Regards,

Prasanna.

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