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.

In the year of Our Lord Thu, 14 Dec 2000 11:14:10 -0500, "Parker, Jack" <JParker@engage.com> broke a vow of silence to utter: >The last time somebody listened to a Bush, folks wandered in the desert for >40 years. This just shows that Democrats have their heads up their collective -- George Bush was only president for 4 years. And, in total, there's been only 12 years since he was voted in. And even if you blame Clinton on Bush Sr, that's still nowhere near 40 years. :-p