| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance on SQL which is using linked objects
put the remote table as last in the from clause.
Oracle is reading alle records from the most last table after from and
then combine it with the others.
example
table1 = local
table2 = remote
select ....... from table1,table2 where .......
"PL.V. Kathiresan" wrote:
> Hi:
>
> I've an SQL which is using objects from two instances,
> through the DB link. When I select the values separately
> from the different instance's objects, it is very fast
> in retrieving the data (as per the plan). But it is
> very slow when the objects and the conditions are combined.
>
> What could be the problem ?
>
> Kathiresan
--
 |
 |