Archives of the TeradataForum
Message Posted: Thu, 19 Nov 2009 @ 11:34:00 GMT
Subj: | | Re: Creating a table and Collect Stats |
|
From: | | Parija, Soumya Ranjan |
Yes it's a good practice when you define columns in ascending order with respect to size particularly when you are going to use multi
stats.
Multi-Column Statistics: More Effective when Short Columns Come First because Order of columns within the collected statistics will be the same
order as in the CREATE TABLE statement.
When varchar columns are present , they are converted to full length before statistics collection. 16 byte interval limit may be exceeded with
just the one column. Best when varchar columns appear last in multi-column statistic.
Thanks,
Soumya
|