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

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizing a join

Re: Optimizing a join

From: EscVector <Junk_at_webthere.com>
Date: 19 Mar 2007 12:16:31 -0700
Message-ID: <1174331791.861123.312800@e1g2000hsg.googlegroups.com> 





On Mar 19, 2:52 pm, "tim" <tragg..._at_gmail.com> wrote:


> Here's the XPLAN

>

> SELECT STATEMENT   Cost = 699

>   NESTED LOOPS


>     TABLE ACCESS FULL STAFFWARE_CALLBACK_QT


>     FILTER


>       REMOTE



You should try generating the plan on the remote database.  This is
where you need to look.
Received on Mon Mar 19 2007 - 14:16:31 CDT












Original text of this message













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