Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.pipex.net!news.pipex.net.POSTED!not-for-mail NNTP-Posting-Date: Thu, 03 Mar 2005 03:21:29 -0600 Message-ID: <+mJaaXBBatJCFwvI@jimsmith.demon.co.uk> Date: Thu, 3 Mar 2005 09:18:57 +0000 From: Jim Smith Newsgroups: comp.databases.oracle.server Subject: Re: Strange Problems with 2 Similiar Queries References: <1109684424.274708.48960@z14g2000cwz.googlegroups.com> Organization: At Home MIME-Version: 1.0 Content-Type: text/plain;charset=us-ascii;format=flowed User-Agent: Turnpike/6.03-U () Lines: 19 NNTP-Posting-Host: 81.6.247.105 X-Trace: sv3-v1j5FKCyknjtJJFWkX5qKwHmHlpXL12rC/jn8tBl1R4BkINqpcxs/ET8nEk+PjolYRX2fk4WKkW3kag!JAGrorwJxFfmI56rwKxsVpXDrmPo0rKmXfiAXn8HqM8oOMRXvaYc0hQp8fQtDpBoH1guFUZgh3Bb!qE/ixl5nRDVoPQ== X-Complaints-To: abuse@dsl.pipex.net X-DMCA-Complaints-To: abuse@dsl.pipex.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237343 In message <1109684424.274708.48960@z14g2000cwz.googlegroups.com>, Paul Izzo 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