Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2007 @ 10:15:24 GMT


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


Subj:   Cache in teradata?
 
From:   Anomy Anom

<-- Anonymously Posted: Tue, 13 Nov 2007 17:28 -->

Hi,

In case of oracle if we run same query twice in short interval of time, the time taken to produce the results second time may be significantly lesser. This is because of Cache concept in Oracle. Does anything similar happen in Teradata? If I run same query twice will I be seeing a better performance when it is run the second time??

I understand that we do have dictonary cache which may speed up the creation of plan but I don't it should affect performance by more then 4-5 secs. Do you see any other reason for same query taking 1min during one run and 15-16 secs during second run?

Request you opinion and help on this.


Thanks



     
  <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