Re: How will I adapt from Pick to Oracle?

Where did you get the information that this is how SQL databases ( if there are such things, rather than RDBMs that are SQL based) do joins...In my anaysis of the performance of my Oracle stuff, unless I [ and not the RDBMS] have made some outlandish programming mistake, I never have seen any cartesian joins, much less huge ones...

Ray DeGennaro <SeeReply-To_at_eaglerock-is.com.invalid> wrote:

>In article <xJbw6.14197$TW.58834_at_tor-nn1.netcom.ca>,
> "Albert Kallal" <kallal_at_msn.com> wrote:
>
>>What was one record, now becomes 3 tables, and two of them are
>>multi-records. YOU have to work out this relation stuff when doing
>>updates. The sql engine might enforce RI for you, but that just stops
>>your code from doing something wrong!
>
>And what's even worse is the way SQL databases typically do joins. A
>big (sometimes HUGE) Cartesian product is formed, and then the rows that
>don't match are eliminated. So, if you aren't careful, your select can
>return results that don't really exist in your database.
>
>
>Ray
Received on Mon Apr 02 2001 - 12:11:56 CDT