on 04-10-2018 8:34 AM
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?
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.