Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Hana compile time of a stored procedures

Hello,

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

Former Member
Not what you were looking for? View more on this topic or Ask a question