Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2002 @ 17:32:43 GMT


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


Subj:   Re: Does Teradata have anything similar to Procedural caching (supported with SQL Server)
 
From:   Jim Downey

Bhupesh,

Two suggestions you might try depending on your specifics. Teradata takes a few moments to calculate an access plan. It is my understanding that when you define a macro, the access plan is calculated. Wrap your query in a macro to eliminate the 'planning' step. (Others on this forum can describe this better) Rewrite your query as a single amp operation. Make sure you are doing row locking and not table locking. Access data on the same amp.

Jim



     
  <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