OPTIMIZE FOR AD HOC WORKLOADS SQL Server by Amit Bansal

14 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.

Data Platform Virtual Summit 2020

Leave a Reply

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