Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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>Received on Thu Mar 03 2005 - 03:18:57 CST