Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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;

     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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016