Skip to Content
0

Updated HANA view and plan cache

Apr 10 at 07:34 AM

21

avatar image

Hi, willl HANA always invalidate prepared statements in cache when (parts of) views are updated? Suppose a SQL query is invoked on top-level view, calling tens of underlying views. All views are executed in the SQL-engine. Then a minor change is made in a ranker in a lower level view, without impact on the SQL-statement that is invoking the top level view. Will the statement be prepared again?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers