Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Nov 2009 @ 11:09:01 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Creating a table and Collect Stats
 
From:   Victor Sokovin

  Pls let me know the points to be taken in to creating a table and defining columns and its data type  


You know there are people out there teaching data modeling courses and some even write books on the topic. It is a big subject.


  Is it true that while defining columns we should all ways declare in ascending order wrt to the size occupied by the columns as a best practice  


In Teradata, there is no technical impact in doing this but it can be convenient for users to display data in a certain default way when they issue SEL * type of queries.


  Came to know that there is some link between collecting stats on a table wrt to the size occupied by the column while creating the table !!!!!  


There can be sizable columns for which you don't want to collect any stats. Containing long unstructured VARCHAR texts, for example. So, always try to use courses, books, talk to knowledgeable people and, last but not least, think before collecting those stats.


Victor



     
  <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: 15 Jun 2023