Archives of the TeradataForum
Message Posted: Thu, 19 Jan 2006 @ 11:13:06 GMT
| Subj: | | Re: Differences between queries |
| |
| From: | | Kumar, Upendra |
Cartesian product is an unconstrained CROSS join .. ( Missing where clause)
CROSS JOIN is ANSI equivalent to PRODUCT JOIN which happens to be a Teradata extension.
There are some real-world uses for Cartesian product joins. One important use is to benchmark system performance with large data throughputs.
Cartesian products make it easy to generate very large answer sets.
Regards
Upen
| 
