COLLECT STATS is one on the most useful utility in Teradata. It helps Parsing Engine (PE) to make an effective plan to execute query, so that less resource are utilized and performance is improvised. But there is a serious confusion between doing COLLECT STATS on column level or table level. Here i like to explain …
