I am currently working on a couple of SQL related questions as part of an intake for a job I am applying for. I was able to answer all questions but there is one I am having trouble with. It relates to SQL query plans, something I am not too familiar with.
The question simply reads:
The query plan in the picture below is not performing well. What can you do to improve it?
Any help or tips will be appreciated. I have been looking into Table Spools and Nested Loops but I have trouble applying best practices to this case.