Joe Weinstein wrote:
>
> Hi all. I had a customer report that the query below
> scans the table. Can that be true, that Oracle doesn't
> realize during construction of the query plan that
> the search argument will never be satisfied?
>
> SELECT 1 FROM ACTIVITY_ENTRY WHERE (1=0) FOR UPDATE
>
> The customer said:
>
> "This query ends up scanning a very large table of ours and
> exceeds a timeout value. Our DBA made some changes to an
> index to temporarily workaround the issue, but we want to
> understand why this is happening."
>
> Thanks,
> Joe weinstein at BEA Systems
>
>
What is this query trying to do ?
Received on Fri Apr 07 2006 - 20:42:17 CDT
