advanced code snippet search

Posted By

hairajeshk on 12/17/10


Tagged

compile sp


Versions (?)

To make an SP Recompile

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.