mysql - Is there anyway to speed up a long OPENQUERY -

i running openquery follows structure similar one:

select distinct p.x, p.y, etc...  [data].[dbo].[datap] p inner join openquery(localdb, 'select ... left join(... left join (... inner join... inner join(...') oq on (oq.x = p.x) p.x > 0 

are there better practices optimizing open query?

create temp table or cte store results of openquery, , join it.

select * #temp openquery(localdb, 'select ... left join(... left join (... inner join... inner join(...') oq 

then in main query:

select distinct p.x, p.y, etc...  [data].[dbo].[datap] p inner join #temp oq on (oq.x = p.x) p.x > 0 

it add possible filtering conditions openquery reduce result set on remote server.