Skip to Content

Hana views: materialization of intermediate results


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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers