Archives of the TeradataForum

Message Posted: Thu, 05 May 2005 @ 19:22:32 GMT

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

<-- Anonymously Posted: Thursday, May 05, 2005 15:06 -->

We do logging for all users, all databases for all statements SQL. We extract the information thru mainframe once a week a keep it for 2 years for security concern.

We did some test to verify than the PRIMARY INDEX ( LogonDate ,LogonTime ) for AccessLog table is very bad specially for request send by Ms- Access.

We never understand wy CNR choosen this primary index

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