Hi, I am in need of help tuning the following section of the query, pasted below.

Gary Arutyunyan 2016-11-29 00:07:28

SELECT
Object8.Column2,
Column5 = Object8.Column6,
Column7 = MultiPartIdentifier1.Function1(),
Object8.Column8,
Column9 = ? FROM
(SELECT
Column2 = Object9.Column2,
Column6 = Function2(DISTINCT Object9.Column3),
Column8 = Function3(Object9.Column8)
FROM (
SELECT
Object3.Column2,
Object3.Column3,
Column8 = Function3(Object10.Column8)
FROM Object5 Object11
INNER JOIN Object7 Object3
ON Object3.Column3 = Object11.Column3

CROSS APPLY Schema2.Object12(Object11.Column4, Variable2) Object10
WHERE Object10.Column7 IS NOT NULL
 
GROUP BY Object3.Column2,
         Object3.Column3) Object9
 
GROUP BY Object9.Column2) Object8