Hana compile time of a stored procedures
When looking at our vizplan of various stored procedure call, the compile time of every procedure seems to be a significant cost of execution. I was expecting to have compile time on the first call of a stored procedure, then subsequent calls to that plan to have minimal compile time.
Is it fair when seeing significant compile times (500ms - 1000ms) on a call to a procedure consistently that something inside the procedure is forcing a recompile? Is there anyway to avoid recompile a procedure and used a previously cached plan (not sure if valid Hana lingo).?