Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Apr 2004 @ 14:39:54 GMT


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


Subj:   Re: Views
 
From:   Jason Fortenberry

Martin,

There was a thread on this a few months back that may offer some help:

www.teradataforum.com/teradata/20040213_201241.htm

The only real alternatives seemed to be working with aliasing where possible to reduce the fully qualified size or break one large view into 2 or more separate ones where a main view joins them all together. The latter just requiring significant explain analysis to insure performance doesn't take a hit.

For a different approach, perhaps you could put your case logic into a look-up type table that could be joined to if the resulting where clause could be made smaller than the case statement? If nothing else, this would be much easier to maintain than a view definition if the data ever changes.


Good luck,

Jason



     
  <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: 15 Jun 2023