Re: Strange Oracle Optimization

Kin Ng wrote:

> Until my DBA fixed the Explain Plan problem (getting Plan table not
> setup error), I can tell you that when I changed the result to a
> single row Count(*), I still get much faster result (12 seconds vs 43
> seconds). If I break the query into 2 parts by storing the result
> from the 1st part in a table and join the table with the 2nd part of
> the query and the result is fast without the RowNum > 0 clause. We
> are at 9.2 already so this isn't something old.
>
> <snipped>

Show us the explain plans.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)