select *
from (SELECT /*+driving_site(a)*/
a.*
FROM cs_mt_bak_one@DBLINK61 a
LEFT JOIN cs_user c
ON a.reserved1 = c.id
LEFT JOIN cs_resp_one@DBLINK61 j
ON a.id = j.mid
WHERE 1 = 1
and (j.sid = 1 or j.sid is null)
and j.result is null
ORDER BY a.request_time desc, a.id)
查询的数据大约在200万左右。但是查询需要6-8秒。如何优化DBLINK查询。