Archives of the TeradataForum
Message Posted: Tue, 16 Dec 2003 @ 18:44:31 GMT
| Subj: || || Re: Collect Stats on Single Column SI |
| From: || || Arunachalam, Sankar |
When you do it on column the stats go to TVFields and on index it goes to the indices. But it lets you do both even though the stats on
the column is collected and is available it goes on to recollect on the index? May be because the stat-engine does that on the base table
vs. the index sub table based on the command request. I wish Teradata get rid of this redundancy.