Archives of the TeradataForum
Message Posted: Fri, 12 Dec 2003 @ 23:58:08 GMT
| Subj: || || Re: Collect Stats on Single Column SI |
| From: || || Christie, Jon |
Statistics are always collected from the column(s) in the primary subtable. It is not possible (and not really useful) to collect stats
on an index subtable.
The dividing point in statistics is whether they are collected on a single column or on multiple columns. Before 5.0.0, it was
impossible to collect statistics on multiple columns unless there was a secondary index on that group of columns. As an implementation
detail, single column stats (whether you used column or index syntax) are stored in DBC.TVFields while multiple column stats (whether you
used column or index syntax) are stored in DBC.Indexes.