Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 13:52:33 GMT


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


Subj:   Long time to CREATE VOLATILE TABLE
 
From:   Kambhoji, Naveen Ram Prasanna

Hi All,

I am creating a volatile table using

     CREATE VOLATILE TABLE A AS(

           SELECT Statement
           ) with data on commit preserve rows;

When I run the individual Select statement it takes only 1 minute to execute but when i run with CREATE VOLATILE TABLE it has taken 7 HOURS to complete the query. Can anyone please explain the reason behinf this. I am running this through a BTEQ session and SELECT Sttmt involves many joins involving fact and Look UP tables. Does Indexes have anything to do with CREATE VOLATILE TABLE sttmt..pls rescue me folks


Thnx,

Prasanna.



     
  <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