Re: Oracle scans table with "WHERE (1=0)"?

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sat, 08 Apr 2006 21:14:57 -0700
Message-ID: <44388A41.7010806@comcast.net>

Joe Weinstein wrote:
>
>
> Mark Townsend wrote:
>

>> Joe Weinstein wrote:
>>
>>> Response from a TAR (SR).
>>
>>
>> TAR number ? I would enjoy shaking some trees...

>
>
> Thanks: 5313790.993 Do let me know what you find out.
>

I note that the analyst's last update (as of yesterday) was that he would check with Dev as to what was actually happening. I have assisted in that process.

For my own information - who made the comment about "Oracle won't invest the serious work required to change their query engine to optimize such queries." Received on Sat Apr 08 2006 - 23:14:57 CDT