What is also missing is the DDL for the tables you are using along with the current indexes defined on those tables.

Part of the problem you are having may also be attributed to poor indexing of the tables.