Re: Problem with optimizer of Oracle 8.0.4 & .5 Server on NT

From: <michael_bialik_at_my-deja.com>
Date: Thu, 07 Oct 1999 20:43:56 GMT
Message-ID: <7tj0m8$9dg$1@nnrp1.deja.com>

Hi.
Is it possible to post the query source?

Did you try to simplify the query and see ( by adding line after line ) where it stops working/explining?

Michael.

In article <7ti419$1u4c$1_at_mail1.pvt.net>, "Tomas Mraz" <tomm_at_NOkamaradSPAM.cz> wrote:
> Hello there,
> I have a problem with runnig queries on table when using complex
AND/OR
> expression
> in the WHERE clause. When I try to run this query the Oracle process
which
> serves this query hangs. When I try to explain plan for the same
query it
> hangs too. I think it's some error in the
> SQL optimizer.
> Has anyone simmilar experiences? Some help?
> I've tried insert a /*+rule*/ hint into the SQL statement, but it
didn't
> change anything.
>
> Tom Mraz
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 15:43:56 CDT