[Improvement] Timeout when deleting orphan entities on large datasets

[NG85]

Description:
When the dataset size grows large, deleting orphan entities frequently times out

Context:
Dataset size: Over 45,000 entities

Investigation & Mitigation Attempted:
We've verified the following in our environment: Replaced the original OUTER JOIN + scalar_subquery logic with EXISTS subquery