Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Merge Data Sets
On Wed, 26 Sep 2001 08:48:13 +0100, Andy Johnson
>>
>> these table have no join key and thier is around 25 million
>> rows..
>
>I assume you understand the term cartesian product? If both
>tables have 25 rows, then you will create 25 x 25 = 625 rows.
>Therefore, your cartesian product will create a 625 million row
>table.
>
As i read th message there 25 mill rows in each table.
The result would be 625.000.000.000.000 rows.
A million times more than 625 million rows.
Yours Hans Erik Busk
tbf_at_cn.stam.dk
Received on Wed Sep 26 2001 - 08:30:53 CDT