Archives of the TeradataForum
Message Posted: Wed, 15 Jan 2003 @ 15:00:31 GMT
| Subj: || || Re: Strange Product Join? |
| From: || || Harold D Kleven |
Sadly, as is often the case, not enough info was provided. But several people correctly inferred that this is a smalltable:largetable
situation (smalltable 217, largetable approx 360M - yes, it's a 72 amp system) but a product join would have resulted in a much larger
rowcount and we didn't get that. Looks like a merge join statisticly but a product join was the word used.