RE: temporary space - doesn't scale?

> The last time somebody listened to a Bush, folks wandered in the desert for > 40 years. Ah, but the reality is that they *didn't* listen to the Bush, and that's *why* they wandered in the desert for 40 years!!! :-) Paul Mosser -----Original Message----- From: Parker, Jack [mailto:JParker@engage.com] Sent: Thursday, December 14, 2000 9:14 AM To: informix-list@iiug.org Subject: RE: temporary space - doesn't scale? > -----Original Message----- > From: Andrew Hamm [mailto:ahamm@sanderson.net.au] > Sent: Wednesday, December 13, 2000 6:52 PM > To: informix-list@iiug.org > Subject: Re: temporary space - doesn't scale? > > > georhill@my-deja.com wrote in message <918aml$ruc$1@nnrp1.deja.com>... > >Looks to me like you've joined P1 to T and P2 to T but you haven't > >joined P1 to P2 so the engine is doing a cross product on P1 and P2. > >Since P1 is the same table as P2, then if P1 has 6,000 rows, > P1 x P2 = > >at least 36,000 rows in the result set (ignoring T). > > Ehh yes. If you are new to Informix, but perhaps familiar > with an engine > that automatically does joins between tables, well, informix > doesn't. Sadly > you must spell out all joins between tables. > Sorry, I must have must have missed something here. A database that automatically joins tables to one another? How do you use such an animal - what is your application that requires this? cheers j. The last time somebody listened to a Bush, folks wandered in the desert for 40 years.