Archives of the TeradataForum
Message Posted: Mon, 22 May 2001 @ 00:47:14 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|