title: Option Recompile makes query fast - good or bad?
body: <p>I have two SQL queries with about 2-3 INNER JOINS each. I need to do an INTERSECT between them.</p>
  
  <p>Problem is that indiividually the queryes work fast, but after intersecting take about 4 seconds in total.</p>
  
  <p>Now, if I put an OPTION (RECOMPILE) at the end of this whole query, the query works great again working quite fast returning almost instantly!.</p>
  
  <p>I understand that option recopile forces a rebuild of execution plan, so I am confused now if my earler query taking 4 seconds is better or now the one with recompile, but taking 0 seconds is better.</p>