Thursday

A New Record! Umm.. what comes after Trillion?!

For those that don't know, quadrillion comes after trillion. I had to look it up....

What do you get when you add together:
  • cost of 2,652,527,734,267
  • cpu cost of 729,606,778,262,148,864
  • order by on 200,474,167,178 rows
  • 87 full table scans
  • 5 merge join cartesian
One nasty query!

The following screenshot was taken today and has officially taken first place in my record books!

4 comments:

Gary Myers said...

Looking at the time, it would take over a thousand years to run.
You'd think at some point it would just say, "Nah, this is just getting silly"

Noons said...

this reminded me of some SQL a few years ago we called the "legacy queries": our grand children would see the results!

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Sridevi Koduru said...
This comment has been removed by the author.