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.

17 views

Leave a Reply

Your email address will not be published. Required fields are marked *