Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2006 @ 18:20:33 GMT

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

'Capture and run' ... that may explain the difference.

If you run the same query soon after it finished parsing Teradata may find it in the statement cache. In this case it will not have to redo the parsing so it runs much more quickly.

If you run the same query using Queryman the following day (or even an hour later) you may find it takes 20 minutes again since it will probably no longer be in the cache.

(Normally a query would not be cached the first time it was seen, but if Cognos submits it as a paramererized query then it probably would... or maybe TD now caches all 'very complex' queries. [That is not my area of expertise])

Mike Dempsey
Teradata Client Tools

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