Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 07 Jan 2004 @ 01:30:00 GMT

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

Subj:   Re: View Performance
From:   Christie, Jon

Run explains on both requests. They should lead you to the problem. Look for unevenly distributed spool files or spool files who's actual size differes greatly from their estimated size. You'll have to write queries to answer these questions, of course. Are you familiar with the hash functions? You'll need to use them to determine spool file distribution.


  <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: 28 Jun 2020