Archives of the TeradataForum
Message Posted: Thu, 26 Jun 2003 @ 12:13:21 GMT
I'm a manager of a team of data analysts who use a 4 node Teradata 5300. I am not strong on the technical aspects of the mechanics of the operating system and would like some advise from this learned group.
Our system has been dieing recently and both our in house DBAs and NCR are struggling to find a reason. The symptoms are that responses become slower and slower until the machine is blocked and needs restarting. The problem, to me, appears to be at the access logs as the problem is first noticeable when dropping or creating tables but not doing selects.
Our DWH Manager has advised during this investigation that we should not use the CREATE TABLE in the format
CREATE TABLE T1 as
Instead we should use
CREATE TABLE T1
The advise we have is the first form is inefficient and causes additional load on the dictionary.
My question is do people have an opinion on either of these methods? If our DBA is correct then why does NCR Training teach this technique globally in their training courses?
Thanks for your interest.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|