OPTIMIZE FOR AD HOC WORKLOADS SQL Server by Amit Bansal

2 views

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.

Leave a Reply

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