Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2005 @ 10:00:10 GMT


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


Subj:   Re: Different Explains for the same query
 
From:   Rohit Revo

It seems there is a DR raised for this problem. Its DR 87815.

We are on Release 05.00.03.29 and need to have a patch installed to overcome this problem.

The problem in our case was that it Redistributed a table when using Queryman ODBC.

And when the same query was used in a macro, the Table (2 GB)inside a Derived Table, got duplicated on all 104 AMPs and had to work 104 times.

     ----------------------------------------------------------------
     DR 87815 All DT in a session gets spooled when a macro using DT
              and system function is executed
     ----------------------------------------------------------------

Regards

ROHIT



     
  <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