Late materialization insert processing

[former_member234712]

Hi gurus, I´ve a performance problem inserting a large result-set (180M), coming from a select clause, into Hana DB. Although the sql clause runs ok, when i add the insert clause, i get an OOM. I have studing the case carefully, and looking for a late materialization issue. The plan of the select with and without insert are the next:

In the insert, we dont have a Late Materialization processing. Since it´s an error new for me and is difficult to find appropiate documentation, i can´t figure out if thats the normal behaviour, or not. Should has the insert COLUMN SEARCH operator the LATE MATERIALIZATION processing?

lars.breddemann any inside advicing would be really appreciated! Sorry for the inconvenience, if you came to Mallorca you have some beers for sure 🙂

Kind regards!

[former_member234712]

Forget to say that the late materialization threshold for both select and insert are much less than the expected number of records, so shouldn´t be that the problem.