Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2012 @ 10:29:49 GMT

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

Subj:   Re: Different AMP CPU time on same query
From:   Machha Narayan Rao Naidu


Are you running it in same session. try logging off and rerunning the query Again.

When you run queries, the results of the initial IO reads are stored in cache. When possible, subsequent runs of the query will access the data from cache rather than re-reading it from disk. Reads from cache reduce the TotalIOCount and AMPCPUTimes. The values of these two totals will vary based on how much of the data has been aged out of the cache by other work executing on the system.

More information on




  <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