Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL: View performance problem

Re: SQL: View performance problem

From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1997/01/18
Message-ID: <32E0960B.5E4E@jlcomp.demon.co.uk>#1/1

I would guess that you have got a correlated subquery taking place which is (by default) being postponed to the end of the plan. If this is the case (check with explain plan), then you may be able to use the PUSH_SUBQ hint to make the subquery run at the earliest possible point in the query.

---
Jonathan Lewis.
Received on Sat Jan 18 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US