[help] mssql linked server query is slow

[Barry]

Hello friends, I have a linked server set up. When I run the query below with SELECT*, it returns the data to me within 2-3 seconds. However, when I run a DELETE, the result comes after 6 minutes. DELETE FROM LINKED.[DATABASE].DBO.TABLE WHERE COLUMN1 IN (SELECT COLUMN1 from LINKED.[DATABASE].DBO.TABLE WHERE (COLUMN2='ABC' or COLUMN3='11') AND COLUMN4='22') I would appreciate any help from friends who have experienced this before or have an idea. Have a great day.