Hi,

It doesn't return any records, but does a 10798 logical read every second.

Upon checking further, indexes are missing it seems. Especially on some foreign keys.

Currently application team is analyzing that query as per our recommendation.

Thanks a lot for clarifying. I may keep updated the status.