Re: Prepared statements plan_cache_mode considerations

2023-10-26 Thread David G. Johnston
On Thu, Oct 26, 2023 at 10:56 AM Zain Kabani wrote: > I was looking into using prepared statements and using the auto > plan_cache_mode. The issue is that the current sample of data collected to > determine whether to use custom plans or the generic one is very small and > susceptible to a bad se

Prepared statements plan_cache_mode considerations

2023-10-26 Thread Zain Kabani
Hi team, I was looking into using prepared statements and using the auto plan_cache_mode. The issue is that the current sample of data collected to determine whether to use custom plans or the generic one is very small and susceptible to a bad set of queries that might pick the suboptimal choice.