DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

Ugliest Query In the World

This is an Apex query and it no longer exists in the environment it once resided in-  When I first came across it, the first red flag was the optimizer cost of 109 billion, (yeah, I had to count the numbers a couple times in disbelief…)  I was reminded of it when Chet from OracleNerd tweeted about a poorly written Apex query and I had to share.  All names and identities have been changed to protect the innocent, (and more likely, the guilty…)

Enjoy!
UgliestQuery!

Print Friendly

facebook comments:

  • Facebook
  • Google+
  • LinkedIn
  • Twitter