OPTIMIZE FOR AD HOC WORKLOADS SQL Server by Amit Bansal

This is a good option to optimize plan cache and avoid plan cache bloat. Better for OLTP environments with many single-use ad hoc queries.

   
94 views

Leave a Reply

Your email address will not be published.