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

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Brandon.Allen@xxxxxxxxxxx
  • Date: Fri, 18 Dec 2009 14:20:24 -0700

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!  I'd suspect your developer might benefit from reading this link:

<http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#sthref3170>http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#sthref3170

I had to test it and found it's 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 

Other related posts: