Archives of the TeradataForum
Message Posted: Mon, 19 Jan 2004 @ 09:52:43 GMT
| Subj: || || Re: Explain Plan |
| From: || || Narayan Murthy |
Duplicate - is creating a replica of the spool(intermediate resultant set of rows) on all the amps(/participating amps).
redistribute - this is done when the a column participating in a where clause is something other than the primary index. In such case that non-
primary index column is hashed and that(those) row(s) are hash re-distributed so that they reach an amp which matches with the newly created