Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 05 Sep 2003 @ 16:02:44 GMT

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

Subj:   Re: Query time
From:   Terry Stover

I'd use PMON and look at the disk io and cpu time for the query. Execution time isn't reliable unless you're the only user on the server. Queryman is good for timing individual queries. For testing new batch processes I put them in BTEQ and add a step to write to a log table between each query.

  <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