Maybe you need to add some indexes to the tables. Do you have any index specified currently on any of the tables?
It's very hard to help you without the table DDL and the query involved.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP