Home Page for the TeradataForum

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


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.


  <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