Archives of the TeradataForum

Message Posted: Mon, 25 Sep 2006 @ 21:22:32 GMT

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

You can query the dbc views called IndexStats, ColumnStats, and MultiColumnStats in order to find out which columns have stats in them. >From that information you should be able to write SQL that generates the "Collect Statistics" commands.

Hope this helps,

Tony

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