Archives of the TeradataForum

Message Posted: Thu, 08 Sep 2011 @ 12:43:27 GMT

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

I know I could write the SQL, but I'd rather not reinvent the wheel if someone has it handy.....does anyone have SQL that generates collect stats statements for all NUSIs? We have single and multi-column NUSIs and most are not named, so I have to generate as

Collect stats dbname.tbname index (col1, col2); etc

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