Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 17 Aug 2001 @ 12:36:35 GMT


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


Subj:   CREATE TABLE AS???
 
From:   Tony Howe

I have a customer that is doing the following:

create table lid5ueg.anes as
(     select
     provspec,
     place2,
     provid,
     oempid,
     memberno,
     dchdate,
     billspec
      from DB2WHSP.V_RALS_iP_CLAIM
      WHERE dchdate BETWEEN '2001-01-01' AND
               '2001-02-28' AND CLAIMTYP = 1)
 with data

This will run for hours, but if you pull the SELECT out and run by itself, it completes in minutes???

I did the EXPLAIN, but don't understand what's holding it up. The explain says it should complete in minutes as well.

Can anybody enlighten me as to what may be happening here??

Thanks, Tony.



     
  <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