Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query with dblink runs slow
Bill Wong wrote:
> I have a query that retrieves data from a secondary database (TEST2)
> via a dblink from the primary database (TEST1) at which I logged in.
> It took 2+ minutes to run.
>
> I copied the query, removing the dblinks and ran it in TEST2. It took
> only 9 seconds.
>
> Any suggestions?
Slow network connection
DB Link queries don't use indexes
It is the nature of the beast.
Daniel Morgan Received on Thu Jul 25 2002 - 17:27:17 CDT