title: my query is taking too 10 seconds to execute how to reduce time and its having many subqueries how to over come this
body: <pre><code>SELECT        
      p.ID, p.EMAIL, 
      'Sales : ' + STUFF((SELECT ', ' + coordinator
                          FROM tbl_clientCoordinators l
                          WHERE type = 'SALES' AND p.ID = l.client_ID 
                          FOR XML PATH('')), 1, 1, '') + ' |  ' + 'R.M : ' + 
              ISNULL(STUFF((SELECT ', ' + coordinator
                            FROM tbl_clientCoordinators l
                            WHERE type = 'RELATIONSHIP MANAGER' AND p.ID = l.client_ID 
                            FOR XML PATH('')), 1, 1, ''), 'N/A') + ' |  ' + 'P.O : ' + 
              ISNULL(STUFF((SELECT ', ' + coordinator
                            FROM tbl_clientCoordinators l
                            WHERE type = 'PROCESSING OFFICER' AND p.ID = l.client_ID 
                            FOR XML PATH('')), 1, 1, ''), 'N/A') + ' |  ' + 'P.C : ' + 
              ISNULL(STUFF((SELECT ', ' + coordinator
                            FROM tbl_clientCoordinators l
                            WHERE type = 'PROCESSING CONSULTANT' AND p.ID = l.client_ID 
                            FOR XML PATH('')), 1, 1, ''), 'N/A') + ' |  ' + 'P.M : ' + 
              ISNULL(STUFF((SELECT ', ' + coordinator
                            FROM tbl_clientCoordinators l
                            WHERE type = 'PROCESSING MANAGER' AND p.ID = l.client_ID 
                            FOR XML PATH('')), 1, 1, ''), 'N/A') + ' |  ' + 'A.C : ' + 
              ISNULL(STUFF((SELECT ', ' + coordinator
                            FROM tbl_clientCoordinators l
                            WHERE type = 'ASSISTANT CONSULTANT' AND p.ID = l.client_ID 
                            FOR XML PATH('')), 1, 1, ''), 'N/A') AS Cordinators
  FROM
      tbl_client p
  </code></pre>