Posted By

hairajeshk on 12/17/10


Tagged

compile sp


Versions (?)

To make an SP Recompile


 / Published in: SQL
 

  1. recompile the keep the sp IN compiled format FOR better performance.
  2. UPDATE STATISTICS PriceListTable
  3. DBCC UPDATEUSAGE (0, "PriceListTable")
  4. EXEC sp_recompile PriceListTable

Report this snippet  

You need to login to post a comment.