Archives of the TeradataForum

Message Posted: Tue, 23 Nov 2010 @ 16:32:45 GMT

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

Hi Jenendra,

You can use DBC.AMPUSAGE to calculate DISK I/O or you can use QRY logging tables too with below conditions.

     ,CASE WHEN  CAST((TotalIOCount / (HASHAMP()+1)) AS DEC(15,2))  < 2.00
                    THEN 0
           ELSE MaxAmpIO/(TotalIOCount / (HASHAMP()+1))
           END (DEC(5,2)) AS IOEFF,

Hope this helps

Thanks

Machha

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