Collect Stats Info

Database

Collect Stats Info

In which dbc tables in teradata is the demographic information
of collecting statistics on tables stored?
Tags (1)
2 REPLIES
N/A

Re: Collect Stats Info

There are 3 locations. DBC.ColumnStats, DBC.IndexStats, and DBC.MultiColumnStats. The table you need to look at depends on which type of statistics you want. Single-column stats (including single column indexes) is stored in ColumnStats. Index stats on multi-column indexes are in IndexStats, and DBC.MultiColumnStats stores statistics on non-indexed multi-column groups. The last field in each contains the histogram of statistics. Dieter Noeth who posts on the forums here has created some SQL that allows you to parse the histogram and see the data.

Re: Collect Stats Info

To see on what column you already have collect statistics defined you can use the following:

HELP STATS .;