 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Sep 2003 @ 18:06:55 GMT
| Subj: | | Re: Will an Index be used with Derived Tables |
| |
| From: | | Dieter Noeth |
Summers, Scott wrote:
| | So for those of use still pre v2r5, what does determine on which column(s) a derived table will be distributed. I was under the
impression that it was the first column too. I believe I was told this at PARTNERS a couple of years ago. | |
It's the column(s) used for a join in the next step. That's why you can get a skewed spool when you join on very non-unique
columns.
Dieter
| |
