Archives of the TeradataForum
Message Posted: Fri, 18 May 2001 @ 14:27:33 GMT
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
(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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|