Pramod/DBA recommended to make the attached query optimization to improve performance.
Improve performance for member interaction tab in research provider. Improve performance for agent to resolve open interactions and service requests over night.
