Read "Don’t optimize for ad hoc workloads as a best practice" by [Randolph](https://bornsql.ca/blog/author/bornsql/) and [Erik Darling](https://erikdarlingdata.com/) https://bornsql.ca/blog/dont-optimize-for-ad-hoc-workloads-as-a-best-practice/