Get rid of it this query will never return a valid result. Does the
ACTIVITY table have a primary key?
Mark Townsend wrote:
> 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 Sat Apr 08 2006 - 08:05:26 CDT
