Archives of the TeradataForum

Message Posted: Fri, 20 Aug 2004 @ 12:14:20 GMT

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

We execute this kind oj job every week to keep track of the production table growth, we keep the result in a table for futur analysing. We having a BTEQ who is create a dynamic BTEQ for inserting the count of each production table.

We did some test and it's quicker to execute many INSERT/SELECT COUNT(*) than using the UNION.

Rudel Simard

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