Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2007 @ 21:44:20 GMT


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


Subj:   Re: Cache in teradata?
 
From:   Anomy Anom

<-- Anonymously Posted: Wed, 14 Nov 2007 16:38 -->

Bob Hahn wrote:

  This is likely due to the operation of the Request Cache. There is good documentation of it's operation in the manual named "SQL Reference: Statement and Transaction Processing", in Chapter 1 Statement Parsing. A short excerpt:  


  "The request cache stores successfully parsed SQL requests so they can be reused, thereby eliminating the need for reparsing the same request parcel.  


  The cache is a PE buffer that stores the steps generated during the parsing of a DML request."  


I agree that request cache can bring down the time required for execution but this should concern the time required for generating the plan of action for the request alone. Do you think any plan creation would take morte then 5-10 secs at max?? I may be reading this wrong but that's how I understand it.


Regards



     
  <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