title: Large Table With Multiple Outer Apply Row Compare Performance
body: <p>I have a large table with a sample query like below to retrieve matched results.</p>
  
  <pre><code>Select col1,col2,col3
  from
  Table1 T1
  OUTER APPLY (select col2 from Table2 Where t2id=T1.id)
  OUTER APPLY (select col3 from Table3 Where t3id=T1.id)
  Where col3&gt;0
  </code></pre>
  
  <p>problem is the its running extremely slow when I have the Where clause column value check.</p>
  
  <p>I have tried different approach including CROSS APPLY, without any improvement to the performance.</p>
  
  <p>Any idea?</p>