Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2008 @ 22:21:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Is there any way to identify the multi-column stats on a table, from the data dictionary?

I need to find all stats defined for specific tables from a script.

The view dbc.columns shows all single column stats, but I cannot figure out where to find the multi-column stats.

These multi-column stats are not necessarily index columns.

Thanks,

Nazy

	<Prev	Next>		<<First	<Prev	Next>	Last>>