Archives of the TeradataForum
Message Posted: Thu, 03 May 2012 @ 17:26:54 GMT
| Subj: || || Re: Dropping stats on indexes |
| From: || || Pluebell, Fred |
Single-column index stats (primary or secondary) are the same as single-column stats. Whether you collect them using the INDEX or COLUMN
keyword makes no difference. These stats remain if you drop the index.
If you collect multi-column stats on the same collection of columns that make up an index, again there is no difference which keyword you use.
These stats go away if you drop the index.
You can specify COLUMN even when there is no corresponding index.