Hi,
On a HANA 2.0 SP3 system I have a INSERT statement that is reading from a calculation view and inserting the results into a column table. The table does not have a primary key and the structure of the table matches the output structure of the CV exactly.
What I have found is when I run the statement in a SQL window in Eclipse the statement takes ~ 6 mins. The CV is "chewing through" ~ 15 BN records, with the output resulting in ~ 22MM records. If I run the same statement in a Stored Procedure calling the SP from a SQL window in Eclipse the execution time takes ~ 20 minutes.
I am hoping that someone can provide some insight as to why the execution time of the two processes would be so significantly different. I have run this test many times, and typically when the system is "quiet" and there are no other DB intensive processes such as loading (the HANA DB is the DB for a BW 7.5 system), or a DB backup, intensive report execution, etc.
Has anyone else experienced similar results, or help to explain why a SP would take so much longer to run the same statement?
Thanks in advance, Mel