title: Bad performance when I insert into variable table instead of temp table
body: <p>The following returns only 3 records and takes less than second:-</p>
  
  <pre><code>SELECT * FROM SomeView Where X='1233'
  </code></pre>
  
  <p>The following takes half minute:-</p>
  
  <pre><code>INSERT INTO @T111
     SELECT * FROM SomeView Where X='1233'
  </code></pre>
  
  <p>It is less than one second if I used temp tables instead:-</p>
  
  <pre><code>SELECT * INTO #TTT FROM SomeView Where X='1233'
  </code></pre>
  
  <p>Explanation please :)</p>