Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizing a join
tim wrote:
> Here's the XPLAN
>
> SELECT STATEMENT Cost = 699
> NESTED LOOPS
> TABLE ACCESS FULL STAFFWARE_CALLBACK_QT
> FILTER
> REMOTE
Unless you have a very old copy of Oracle this is not an Explain
Plan. Please produce them for both the local and remote using
DBMS_XPLAN. Also post your version. Both will help.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Mar 19 2007 - 16:51:08 CDT