Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Apr 2004 @ 07:47:23 GMT


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


Subj:   Reset query plans
 
From:   Singu, Bhupesh

I am running the same query many times (queries are executed serially for testing purposes) and logging the queries response times, cpu and IO. However, when I run the same query second time, thrid time and so forth, there is a significant decrease in response time, io and cpu. I am guessing, this is because of the caching (both data and query plan). Is there a way to reset or clean the data cache and the query plan cached in the system? In SQL Server, the commands are "DBCC DROPCLEANBUFFERS" and "DBCC FREEPROCCACHE". Is there a equivalent in Teradata?


thanks

------------------------------------
Bhupesh Singu
Database Administrator
ITE, Dept. of Administrative Services
-----------------------------------



     
  <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: 27 Dec 2016