Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2003 @ 10:01:25 GMT


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


Subj:   Fastexport and CSUM spool problem
 
From:   MacMillan, Stuart

A we're on the subject of sequence numbers does anyone know the answer for this one?

I'm using an OLAP function within a Fastexport script to write a sequence number.

i.e. .

select
CSUM (1 , Customer_id) as Row_Sequence
, Customer_id
, etc ...

from mytable
;

This runs fine in Queryman but immediately runs out of spool in Fastexport.

o mytable has 150000 rows
o mytable is indexed on Customer_id
o Customer_id is defined as not null
o Ave rows/Customer - 1.2

Looking at DBC.Diskpace my peakspool has blown on the last VPROC so it looks like something is causing skewing.

As a work-around I've inserted sequence number into a work table but I'd like to know why I'm running out of spool.



     
  <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