title: Execution plan not showing - CTRL + L shows only number of rows affected
body: <p>Sometimes when I try to get the estimated execution plan for a query, SSMS will not show any results other than <code>(1 row(s) affected)</code> in the messages pane and "Query executed successfully" in the status bar.</p>
  
  <p>If I try to run <code>CTRL+L</code> on parts of what I wish to do, it will show the estimated execution plans. But this is rather annoying as sometimes I have to analyze part of a procedure which is 700-lines separated from the variable declarations, which has me moving the declaration of variables around to get parts of the plan displayed. But sometimes, some insert and update statements get no result at all, just what I described in the first paragraph.</p>
  
  <p>Is there something that keeps a query from having its execution plan estimable? How do I solve this?</p>
  
  <hr>
  
  <p>Edit: I discovered that this happens when I try to get the execution plan of a couple joined tables that have too many statements in the join, i.e.:</p>
  
  <pre><code>... FOO inner join BAR on contidion1, condition2... conditionN
  </code></pre>
  
  <p>For some reason I cannot figure out yet, reducing the amount of conditions solved the problem. I am still trying to isolate this so as to improve the question.</p>