Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 May 2001 @ 19:22:03 GMT


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


Subj:   Re: Monitoring long-running queries
 
From:   James Judge

Is the Current spool still accumulating? Thanks -- it is still in the select phase.

The result of the second query you suggested gave me the following results...

Sum(CurrentSpool) ((100*Average(CurrentSpool))/Maximum(CurrentSpool))

699225088 11

Does L,M,N allow NULL values (i.e. is there current specification NOT NULL) or default value(s) 0 for numeric and blank ' ' for CHAR? Also what is the cardinality of L,M,N combinations (how many expected unique combinations compared to base rows )?



     
  <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