Re: Grumble - is this really the best they can do?
- From: Dave Morgan <oracle@xxxxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 17 Jul 2016 11:05:09 -0600
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Jared Still
Sent: Saturday, July 16, 2016 3:55 PM
To: woodwardinformatics@xxxxxxxxxxxxxxxx
Cc: Oracle-L Freelists
Subject: Re: Grumble - is this really the best they can do?
Snip .......
What is not obvious is why you care.
Is this a canned app written in a sub-optimal manner?
Sub-optimally generated code?
Something else?
What's wrong with that code? Looks fine to me. Maybe not the best but nothing
wrong with it.
Easily understandable.
Here's some sub-optimal code, final where clause in a production query
and (('True' = 'True') or ("ENV_ORDER_HEADER"."ORDER_ID" in ('False')))
ORDER_ID is numeric
12 years I've been trying to get it fixed.
Sigh :(
I wouldn't grumble if I were you. It can get much worse, much much worse
YMMV
Dave
--
Dave Morgan
Senior Consultant, 1001111 Alberta Limited
dave.morgan@xxxxxxxxxxx
403 399 2442
--
//www.freelists.org/webpage/oracle-l
Other related posts: