Archives of the TeradataForum
Message Posted: Mon, 04 Nov 2002 @ 17:32:43 GMT
| 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.