Observation: Nested Loop Join

You coded a query with a nested loop join, resulting in a tablespace scan on the inner table. There is no available index on the inner table.

Consider creating an index for the inner table.