Archives of the TeradataForum

Message Posted: Tue, 22 Nov 2011 @ 23:06:04 GMT

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

When you run queries,?the?results of the initial IO reads?are stored in cache. When possible, subsequent runs of the query will acces the data from cache rather than re-reading it from disk. Reads from cache reduce the TotalIOCount and AMPCPUTimes. The values of these two totals will vary based on how much of the data has been aged out of the cache by other work executing on the system.

Al Czajkoiwski Solution Architect Teradata Corp.

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