Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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

CREATE TABLE T1 as
(select * from T2)
with data;


Instead we should use

CREATE TABLE T1
(FLD1 integer,
FLD2 varchar(25),
FLD3 dec(15,2) )
Index(FLD1);


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>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016