SAP Knowledge Base Article - Preview

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

Symptom

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".


Read more...

Environment

  • SAP Adaptive Server 15.7
  • SAP Adaptive Server 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.