RE: I need to vent

From: Matt Adams <MAdams_at_TroverSolutions.com>
Date: Tue, 1 Mar 2016 16:51:49 +0000
Message-ID: <ac4822e1783d43f9b21b6a655e40f098_at_wpvl1dag02.hcrec.com>



I've seen queries generated by many different BI tools over the years. Some were bad, some not so much (none were ever great).

But this...this is an order of magnitude worse than anything I've ever seen before.

500 pages for a single statement. I'm still shaking my head in surprise and dismay.

Matt

-----Original Message-----
From: John Piwowar [mailto:jpiwowar_at_gmail.com] Sent: Tuesday, March 01, 2016 11:49 AM
To: Matt Adams
Cc: oracle-l_at_freelists.org
Subject: Re: I need to vent

Exposing DBAs to queries generated by a BI tool without prior warning is so, so cruel.
Rest assured, you are not alone in your pain: the number one user requirement for the output of that query is: "please make sure I can export this to Excel."
Somewhere, the developer of a whiz-bang data visualization dashboard weeps, adds a menu item, and takes another shot.

Regards,

John P.

On Tue, Mar 1, 2016 at 7:56 AM, Matt Adams <MAdams_at_troversolutions.com> wrote:
> 1.8 million characters!!!!! How in bloody hell does ANYTHING write a
> single sql statement that 1.8 million characters long.
**** This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. **** †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Mar 01 2016 - 17:51:49 CET

Original text of this message