Archives of the TeradataForum

Message Posted: Mon, 13 Jan 2003 @ 14:34:35 GMT

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

Depend on how you log your information in ACCESSLOG and what kind of product you read your Teradata.

ACCESSLOG has a PRIMARY INDEX ( LogonDate ,LogonTime ), with MS-ACCESS he writes a huge number of record in ACCESSLOG table. All record will go on the same AMP for the week. That will unbalance this table.

Rudel Simard
R�gie de l'assurance-maladie du Qu�bec
DBA de l'environnement informationnel

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