Archives of the TeradataForum

Message Posted: Tue, 23 Feb 2005 @ 01:50:05 GMT

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

Hi,

On picking a PI, how bad does distribution (skewness) need to get before one abandons an optimal access PI. Also, how bad does a volatile PI need to get. Let's assume duplicate row checking is not a factor (mulitset or USI defined). Any rule of thumb or advise, appreciated.

John Elliott,
DBA, Buisness Data Management -USPS

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