Skip to Content
0
Jul 09, 2019 at 08:03 AM

Do Abstract SQL Plans in HANA prevent recompilation when query text is changed?

133 Views

I know that except Execute and Prepare Plans there is also ASP. It contains information which is helpful for the Optimizer when there is no plan in the Plan cache available for the executing query. But I do not understand its usage. Let's say when query text changes plan needs recompilation, so is ASP used in this case to prevent that? Or if we haven't used that query for quite a long time, and its plan is already out of the cache, there is a huge probability that our ASP can be old and cause more overhead than help. Is this case possible? what exactly is ASP used for?

Thanks for your time !