Archives of the TeradataForum

Message Posted: Mon, 22 May 2001 @ 00:47:14 GMT

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

Helen,

If this is the case and you didn't really define the Primary Index columns then it chose to use the first column by default which is probably very skewed.

If you did specify a Primary index like your last SQL, then I can't see the problem, but it might show up in the explain.

Good Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

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