Re: Query Optimization

From: <bialik_at_wis.weizmann.ac.il>
Date: 1998/05/15
Message-ID: <6ji3r8$sob$1@nnrp1.dejanews.com>#1/1

Hi.

I think that something is missing in your SELECT statement. Try following :
SELECT /*+ ORDERED */ <select-list without any changes> FROM

     MR_MODEL_EXPLODE MME,
     MR_ELEMENT_RELATION MER,
     MR_ELEMENT ME
   WHERE
     MME.EXPLODE_ID = 1 AND
     MME.EXPLODE_IND = 'Y' AND
     MER.ELEM_ID = MME.ELEM_ID AND
     MER.PARENT_ELEM_ID = MME.PARENT_ELEM_ID AND
     ME.ELEM_ID = MME.ELEM_ID;

If it works, try to simplify the statement by droping the hint and using MR_MODEL_EXPLODE table as the LAST table of FROM list.

Good luck. Michael.

Please let me know if it helped.

In article <355A7DE1.C77D5423_at_spacestar.com>, John Flipse <jflipse_at_spacestar.com> wrote:
>
> Hello -
>
> I am trying to optimize an Oracle query, but am running into issues with
>
> the optimizer. We are running on Oracle v7.1, using the cost based
> optimizer.
>

....

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 15 1998 - 00:00:00 CDT