Archives of the TeradataForum 
 
 
Message Posted: Mon, 13 Jan 2003 @ 14:34:35 GMT 
 
  
 
 
 
 
  
|  Subj:  |   |  Re: An Idle question  |   
|     |   
|  From:  |   |  Rudel Simard  |   
  
 
 
  
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 
 
 
 
 
   
 
 |