Archives of the TeradataForum

Message Posted: Sun, 03 Nov 2002 @ 11:04:55 GMT

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

Hi,

Is this a a straight SQL with BTEQ/Queryman or are you talking Stored procedures.

We implemented Object code caching for stored procedures in 4.1. The cache time out is 10 minutes. If no one executes the Procedures within 10 minutes from the last time it was executed it will purged from the cache.

If this was staright SQL, The parser will cache the STEPS necessary to execute a query and if the exact same query is submitted the parser will pull it out of the cache and re execute it.

Have you tried to collect statistics on the tables and columns involved?

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