RIGHT OUTER JOIN DIRECT QUERY

I am using the direct query by using 2 tables and I want to use RIGHT OUTER JOIN to do a merge. But it is taking a long time to merge the 2 tables and it is effecting the production environment. The ...