I need to optimize the query ,any suggestion s is welcome
What I do see is the large discrepancy of estimated vs actual rows on both Object1 and Object2 in the Statement portion. This can indicate out of date statistics. There are several objects displaying a variance of estimated vs actual resulting in the overall different highlighted by the tool on Object2.
Additionally, there are 15 Hash Match operations occurring, some of those may be candidates for improvement with a covering index.