Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 05 Mar 2007 @ 23:43:46 GMT


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


Subj:   Re: Parsing of SQL and macro efficiency
 
From:   Carpenter, John

This depends entirely on the SQL statement involved. If there are embedded comparison values then it will not be cached right away. Only if it is seen again with the same values. Whereas a Macro with parameter values will be immediately cached by the parsing engine and be ready for reuse.


John



     
  <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