Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 04, 2015 at 03:54 AM

    Where are you looking up the numbers?

    What is your SAP HANA revision?

    What are the exact commands you use?

    Generally there is no way to change a procedure and have it use an execution plan that was compiled for a previous version. That works in no DBMS that I know of. As the procedure got changed a new compilation is required.

    One major contributor to recompilation though could be the change of underlying/depending objects.

    If there's a lot of changes happening there, this might explain what you're seeing.

    Cheers,

    Lars

    Add comment
    10|10000 characters needed characters exceeded