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

 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

avatar image By Gary Arutyunyan 1 asked Nov 29, 2016 at 12:07 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x527
x343
x77
x33
x20

asked: Nov 29, 2016 at 12:07 AM

Seen: 358 times

Last Updated: Jan 08 at 04:57 PM