Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 May 2001 @ 14:27:33 GMT


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


Subj:   Monitoring long-running queries
 
From:   Helen Feder

I just started working with teradata -- so forgive me for what are probably very basic questions....

I loaded up a table (A) (size is approx 8 gig)with a unique primary index. I created 2 nupis and collected statistics on the indexes, and columns that would typically be used in where clauses. Now I want to create a new table that contains aggregated data from table (A).

Create B as
select sum (x), sum(y)
from A
Where z between '1' and '3'
group by L, M, N

(I have collected stats on z (not an indexed column), and the columns L, M, and N)

Anyway I submitted this to bteq with .set sessions 10 as a background job in unix and it has been running for several hours.

Is there any way I can find out what is really happening with this query? (The explain gave no total time / cost estimate).

Thanks for any suggestions!



     
  <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