title: Disable auto creating statistics on table
body: <p>Is there any possibility to disable auto creating statistics on specific table in database, without disabling auto creating statistics for entire database? </p>
  
  <p>I have a procedure wich written as follow</p>
  
  <pre><code>create proc 
  as
  create table #someTempTable(many columns, more than 100)
  inserting into #someTempTable **always one or two row** 
  
  exec proc1
  exec proc2
  etc.
  </code></pre>
  
  <p>proc1, proc2 .. coontains many selects and updates like this:</p>
  
  <pre><code>select .. 
  from #someTempTable t
  join someOrdinaryTable t2 on ...
  
  update #someTempTable set col1 = somevalue
  </code></pre>
  
  <p>Profiler shows that before each select server starts collecting stats in #someTempTable, and it takes <strong>more than quarter of entire execution of proc</strong>. Proc is using in OLPT processing and should works very fast. <strong>I want to change this temporary table to table variable(because for table variables server doesn't collect stats)</strong> but can't because it lead me to rewrite all this procedures to passing variables between them and all of this <strong>legacy</strong> code should be retests. I'm searching alternative way how to force server to <strong>behave temporary table like table variables</strong> in part of collecting stats.</p>
  
  <p><strong>P.S.</strong> I'm know that stats is useful thing but in this case it's useless because table alway contains small amount of records.</p>