Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2004 @ 15:24:11 GMT


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


Subj:   Re: CASE Expression Problem
 
From:   Michael Larkins

Hi Eric:

It would appear that you have exceeded the current size of the parser cache. This cache continues to increase over various releases of Teradata. So, someday it will probably work as written. I realize this is little help now. That's the "bad news".

However, the "good news" is that there is probably a better way in Teradata to do what you want. Teradata, via its parallel architecture, is actually better (faster) at doing a join than it is at comparing several literal values. So, my first attempt at a fix for this would be to put the 50 values that you mention into a table using them as the Primary Index. Then, instead of using a long, involved and maybe complicated CASE, simply join the values to the table to retrieve the data you are looking for in the CASE. Another advantage to this approach is that if the data changes, you update the table one time instead of finding and changing multiple CASE statements.

Just a thought and a possible alternative to your situation.


Best regards,

Michael Larkins
Certified Teradata Master



     
  <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