Skip to Content
0

Hana views: materialization of intermediate results

Mar 02 at 01:02 PM

42

avatar image

Hi

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?

Regards

Yann

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

0 Answers