Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2007 @ 17:04:38 GMT

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

This is likely due to the operation of the Request Cache. There is good documentation of it's operation in the manual named "SQL Reference: Statement and Transaction Processing", in Chapter 1 Statement Parsing. A short excerpt:

"The request cache stores successfully parsed SQL requests so they can be reused, thereby eliminating the need for reparsing the same request parcel. The cache is a PE buffer that stores the steps generated during the parsing of a DML request."

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