Skip to Content

Updated HANA view and plan cache

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers