ORACLE remote data relational query excruciatingly slow

The remote tables A 2000W data, B local user departments. Now the need for relational query.
CREATE VIEW XXX as
SELECT *,B.DEPT_ID FROM A@LINK T,B B WHERE T.DEPT_CODE=B.DEPT_CODE
The query statement to run half an hour.
Dear God know how to deal with? Is there any way to optimize.

Started by Edward at November 22, 2016 - 1:46 AM

Atomization view? JOB extraction?
I also encountered such a situation, finally found the table data remote not lazy, direct call

Posted by Stella at December 04, 2016 - 2:42 AM

The following amendments:
CREATE VIEW XXX as
SELECT /*+driving_site(T)*/ *,B.DEPT_ID FROM A@LINK T,B B WHERE T.DEPT_CODE=B.DEPT_CODE

Posted by Molly at December 18, 2016 - 3:25 AM