3256045 - Same SSQL_ID after new plan has been generated - ASE

A query is executed after running "sp_recompile" and "SSQL_ID" is the same of previous execution.

Execute the query before "sp_recompíle":

======

QUERY PLAN FOR STATEMENT 1 (at line 1).

    STEP 1

        The type of query is EXECUTE.

        Executing a newly cached statement (SSQL_ID = 949379916).

.......

.......

======

Then “showplan” indicated: Executing a newly cached statement (SSQL_ID = 949379916).

If we execute "sp_recompile" then we will see:

======

 STEP 1

        The type of query is EXECUTE.

        Executing a previously cached statement (SSQL_ID = 949379916).

=====

But a slightly different plan is generated after:

=====

QUERY PLAN IS RECOMPILED DUE TO SCHEMACT.

THE RECOMPILED QUERY PLAN IS:

.......

.......

=======

We can see that a new plan was generated but using the same "SSQL_ID".

• SAP Adaptive Server 15.7
• SAP Adaptive Server 16.0

SSQL_ID sp_recompile showplan cached statement recompilation query plan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To