Cartesian joins
From: Orlando L <oralrnr_at_gmail.com>
Date: Sat, 30 Mar 2019 15:06:35 -0500
Message-ID: <CAL8Ae77asB2pfkTkuok=1pZTs=ZnCLcHKGBO_zYhs4=HeqoW2A_at_mail.gmail.com>
List
Date: Sat, 30 Mar 2019 15:06:35 -0500
Message-ID: <CAL8Ae77asB2pfkTkuok=1pZTs=ZnCLcHKGBO_zYhs4=HeqoW2A_at_mail.gmail.com>
List
When is it OK to do Cartesian joins?
- It looks like during the star transformation while joining 2 or more small result sets from dimension tables?
- In an ordinary join, when one of the row sources is estimated to be 1 row with the other row source be several thousand? In this case, the Cartesian will be just 1*no of rows in the other table.
Any explanation is helpful. thanks
Orlando.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 30 2019 - 21:06:35 CET