Skip to Content

Hana views: materialization of intermediate results

Mar 02 at 01:02 PM


avatar image


I believe I saw a post on this topic on this forum, but can't find it again...

When writing a Hana view with a SQL script, will Hana materialize all the "intermediate" views in the script (all the select statements in the script) or will it be smart enough to optimize the statements into a merged select that reduces as much as possible the need for materialization? I think I read a post earlier that stated Hana was smart enough - is that correct?

Is it the same approach taken by the optimizer for graphical views as well?



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

0 Answers