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


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.


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