After creating a new VIEW in HANA
CREATE VIEW myView AS
we found that the first select on that view
SELECT * FROM myView;
runs up to 5000 times longer than the 2nd and later SELECTs on that VIEW.
Why does HANA show this behaviour? How can we avoid it? Can we "trigger" a first SELECT / cacheload with a certain SQL-comand (`LOAD myView ALL;` had no effect)?