Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Jul 2006 @ 22:33:16 GMT


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


Subj:   Re: Macro call from JDBC for Tactical Queries
 
From:   Ballinger, Carrie

David and Bob,

There is one wrinkle you need to be aware of when using global temp tables with tactical queries. When global temp tables are used in the macro, the plan will not be cached in the way that standard macros accessing base tables with parameterized SQL will.

This is because each session that uses that macro will have a different table ID for the GTT. Without all table IDs in the query being consistent across all executions of the macro, a generalized, cacheable plan cannot be produced.

This is also true with volatile temp tables.


Thanks, -Carrie



     
  <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