Archives of the TeradataForum

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

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

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>>