Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 05 Feb 2005 @ 19:29:28 GMT


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


Subj:   Consistency in resource usage for an SQL
 
From:   Anomy Anom

<-- Anonymously Posted: Saturday, February 05, 2005 14:29 -->

Does a SQL consume the same amount of CPU/IO resource when executed repeatedly? I experimented executing the same SQL and measured the CPU and IO costs from Ampusage table and it gives me different results although Table data didn't change. Is there any other feature than caching and synchronized scanning that can give me different values every time I run the same 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: 15 Jun 2023