I am working in performance team. I need some help in improving query performance.
In my query they wrote several left outer joins. I want to improve the performance by using outer apply which is similar to left outer join
Suppose in left outer join
from TableA A
left outer join TableB B
For this above query how to write by using outer apply.
In this query, I don't have any functions but I want test the performance by changing into outer apply instead of left outer join.