Re: Strange Problems with 2 Similiar Queries

In message <1109684424.274708.48960_at_z14g2000cwz.googlegroups.com>, Paul Izzo <paul.izzo_at_mosca-ag.com> writes
>I'm running a 9i database with OLAP enabled. I'm looking to run 2
>queries on the same table. The 2 queries are pretty much identical
>except for 2 variables.
>
> The problem that I'm having is that 1 query works and the other
>doesn't and I don't know why. Here's an example of the query that I'm
>running:
>

Can you post explain plan for both queries?

And which version of 9i?

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>