Hi, I am in need of help tuning the following section of the query, pasted below.
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
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