Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Select and Case performance
From:   Anomy Anom

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

     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.


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023