Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 22:05:56 GMT

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

You can check Activity_count. Something like

     IF (ACTIVITY_COUNT > 0)
        THEN
           insert into ZS_INSTANCE_TR
     END IF

We use this type of coding so we only attempt to insert rows when rows can be inserted to avoid JOIN INDEX maintenance. Teradata still uses cycles to maintain the Join index even though no rows were inserted into the tables on which the join index is created.

Thanks,

Bob Diehl

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