Reputation: 198
Am new to SAP HANA, someone suggested me to use views instead of tables for better performance in store procedures is that true. I mean creating calculation view on top of table and use view in procedure instead of table.
Even view will refer underlying table how come it will improve performance please guide.
They say that if we use a table in procedure and any query(other session) is fetching data from same table will cause blocking which might impact performance.
Upvotes: 0
Views: 698
Reputation: 10396
That’s not an accurate statement. The straight intermediate projection won’t add any “speed-up”. And using views within a table function or procedure does not block other processes from reading from it at the same time.
Your colleagues may want to check those assumptions e.g. by using PlanViz trace or EXPLAIN PLAN.
Upvotes: 1