RE: In case you needed something to laugh about today...

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 18 Dec 2009 18:59:51 -0500
Message-ID: <B19D57F780A145C6AC2D84ECF1FA0951_at_rsiz.com>

Reid joined to Pelosi. I'm not sure whether that is Cartesian. and the rest of my thoughts on the topic are self-censored.  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Friday, December 18, 2009 4:20 PM
To: Brandon.Allen_at_OneNeck.com
Cc: oracle-l_at_freelists.org
Subject: RE: In case you needed something to laugh about today...  

That immediately begs the question

"How many cartesion joins does it take to match the US national debt?"

At 01:05 PM 12/18/2009, Allen, Brandon wrote:

Ha ha! Id suspect your developer might benefit from reading this link:  

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.ht m#sthref3170  

I had to test it and found its pretty easy to beat that with a few cartesian joins - I got a cost of 939 quadrillion:

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com <http://www.centrexcc.com/>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 18 2009 - 17:59:51 CST