Archives of the TeradataForum
Message Posted: Thu, 26 Jun 2003 @ 15:30:44 GMT
| Subj: || || Re: Create Table Efficiencies |
| From: || || Judge, James A |
When you say "the machine is blocked" how do you diagnose that, through PMON, UNIX services like PUMA or other GSC tools, or? And the
"... access logs ..." , if that is DBC.ACCESSLOG how often are you administering that table (purging)? The NUPI of the underlying DBC
table can cause inefficiencies based on how often active sessions logon-off. Also if most of your queries are doing CT... then there are
system tables overhead with accessrights,etc.