sql - Inner join speed issue (Linked Server column) -

i have view (view a) pulls in columns number of tables. pulls in column view (view b) gets data linked server table.

now, view b runs fine, pulling 11,000 rows in second. view runs fine. however, if inner join view view b on column comes linked server, entire query runs slow times out.

if inner join view view b on column not come linked server, runs fine.

so traced issue joining on column resides on linked server. have no idea how fix it.

can give me pointers?

the circumstances different, both co-workers , have seen evidence if have this:

select  linkedserver.database.owner.table whatever 

then sql server select entire table other server first, , apply clause afterwards. might happening you.

we solve problem using openquery instead of qualified method shown above, , putting openquery results temp table. join temp table.