Archives of the TeradataForum
Message Posted: Wed, 04 May 2011 @ 11:32:36 GMT
<-- Anonymously Posted: Wednesday, May 04, 2011 03:30 -->
Can some one explain me the difference between collecting stats on partition column vs collecting stats on partitions.
Eg: Consider the below table. I can collect stats on join_date using syntax
Collect stats on emp_summary column join_date;
Also I can collect stats on partitions involved in join_date.
What is the difference between these two approaches
CREATE MULTISET TABLE emp. emp_summary ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, FREESPACE = 0 PERCENT, CHECKSUM = DEFAULT ( emp_SUMM_ID INTEGER NOT NULL, join_DATE DATE FORMAT 'YYYY-MM-DD' NOT NULL, ) PRIMARY INDEX (emp_SUMM_ID) PARTITION BY RANGE_N (join_DATE BETWEEN '2010-01-01' AND '2030-12-31' EACH INTERVAL '30' DAY );
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|