|
|
Archives of the TeradataForum
Message Posted: Thu, 19 Nov 2009 @ 11:09:01 GMT
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
| |