Archives of the TeradataForum
Message Posted: Thu, 05 Feb 2004 @ 21:05:18 GMT
It's entirely up to you. It doesn't look like a good plan to me. Nested joins only make sense then the number of rows that result are less than the number of blocks in the table they came from. Is the secondary index the nested join uses lumpy (very high rows per value for some values) by any chance?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|