The impact of ObjectHierarchy CTE change to `DISTINCT`

We recently introduced the !57052 (merged), which adds a use_distinct_for_all_object_hierarchy.

This does affect the query plan for a big query of jobs/request adding a performance regression that might be a potential problem.