Archives of the TeradataForum

Message Posted: Tue, 18 Mar 2003 @ 12:46:52 GMT

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

This topic is well covered in history but here goes nothing:

Generally you want to collect statistics on:

A UPI of a table with less than 1000 rows per AMP.

ALL non-unique indexes.

For a more complete treatment refer to the manuals and/or TERADATA Users Guide from Coffing.

Larry

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