Skip to Content
0
Former Member
Aug 18, 2016 at 03:12 PM

First SELECT on VIEW 5000x slower than 2nd

22 Views

After creating a new VIEW in HANA

CREATE VIEW myView AS

SELECT

...

FROM

...

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)?