Archives of the TeradataForum

Message Posted: Fri, 08 Jul 2005 @ 08:43:04 GMT

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

<-- Anonymously Posted: Friday, July 08, 2005 04:16 -->

Hi All,

I am trying to run the below given queries on a 2.5 TB call table A with 7 Billion rows.

I want to know whether the second query has any serious performance impact in terms of delaying the results and using more spool.

     Select Cd, Id
     from A;

     select
     Case when (Cd = 'S')
                             Then 'SEC'
             When (Cd = 'X')
                             Then 'ABC'
              When (Cd = 'Y')
                             Then 'XYZABC'
              Else NULL
     End , Id
     From A.

The table is really huge and it is partitioned on Date.

Regards

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