Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 01 Oct 2001 @ 20:07:55 GMT


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


Subj:   Re: Multiload status
 
From:   Thomas F. Stanek

Ruth,

I would have to agree with Eric. I have had similar experiences with very non-unique indices (primary or secondary).

As an aside, I would suggest using AMPUSAGE to get accurate, quantifiable metrics on the CPU and IO consumed for this process. It will help determine the relative difference in resource consumption of variations on the process (i.e. with all NUSIs, with all but the very non- unique NUSI, with no NUSIs,etc.) as well as give some insight into the level or skewing involved, if any.


Regards,

Thomas F. Stanek
TFS Consulting



     
  <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