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.


  <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: 28 Jun 2020