2524082 - Why query plan shows up in the log file - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2524082 - Why query plan shows up in the log file - SAP ASE

Symptom

A query plan is written to the ASE errorlog:

00:0002:00000:00012:2017/08/23 12:53:17.37 server  Optimized using Serial Mode
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server      STEP 1
00:0002:00000:00012:2017/08/23 12:53:17.37 server          The type of query is COND.
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server       1 operator(s) under root
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server         |ROOT:EMIT Operator (VA = 1)
00:0002:00000:00012:2017/08/23 12:53:17.37 server         |
00:0002:00000:00012:2017/08/23 12:53:17.37 server         |   |SCALAR Operator (VA = 0)
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server  QUERY PLAN FOR STATEMENT 60 (at line 435).
00:0002:00000:00012:2017/08/23 12:53:17.37 server  Optimized using Serial Mode


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

showplan, console, terminate , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

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

Search for additional results

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