I know query plan is stored in cache. But if a better query plan appears, I wonder if the previous plan will be erased or both.

Hi @Kim_Hakseon , Per the documentation that @steevej referenced, a query plan that is Active can move to an Inactive state in the cache if there is a better performing plan: The planner also evaluates the entry’s performance and if its works value no longer meets the selection criterion, it wil…

steevej (Steeve Juneau) October 6, 2020, 11:30am 2

I hope you will find the following useful.

About query plan caching