Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2003 @ 12:13:21 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Create Table Efficiencies
From:   Ray Wilson

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

(select * from T2)
with data;

Instead we should use

(FLD1 integer,
FLD2 varchar(25),
FLD3 dec(15,2) )

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.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020