Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2002 @ 02:48:49 GMT

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

I'm afraid I no longer have a copy of the R3 documentation so I cannot match exactly. However, in the Collect Statistics Guidelines section of that book in 4.0 and 4.1 doc sets, that statement no longer exists.

You should always collect stats on NUSIs. The optimizer has little chance of properly using your indexes without stats.

For large tables with a UPI, it is not required to collect stats on the PI. This is the opposite of small tables where collecting on the PI helps us get good sizing information on the table (Small is defined as <1000 rows per amp).

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