Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Jan 2012 @ 14:57:32 GMT

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

Subj:   Re: Performance Metrics: What explains this kind of observation?
From:   Anderson, Dirk

Might want to check for IO or CPU skewing.

Time is certainly one consideration in perf tuning. If the difference in run time is significant, we tend to favor the faster running query, even if it uses more resources, because it's in/out faster. We don't have any particular criteria to make that decision, it's just a judgment call on a case-by-case basis, taking into consideration all the performance metrics.

For curiosity, you might trying running the 2 queries on a busy system....it might be interesting to see if the one demanding greater cpu/io resources (Q2) takes proportionally longer to run when the system is heavily taxed.


Dirk Anderson
SVP, Manager of Architecture & Strategy
Chief Data Officer Organization
Bank of America

  <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