Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Jan 2004 @ 08:35:47 GMT


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


Subj:   Re: View Performance
 
From:   Dieter Noeth

Christie, Jon wrote:

  If you try using this trick, remember it probably won't be effectivevfrom version 5.1.0 up because Teradata plans to fix the problem.  



It's already fixed since 5.0.2 ;-)

From V2R5.0.2 Release Summary:

RFC 56914 In past releases some optimizations that were made when the join term was specified in the WHERE clause were not made for semantically identical queries which specified the join term in an ON clause.

In release V2R5.0.2, semantically-identical queries are optimized identically.


Dieter



     
  <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