BC170_2.15.1

Using the SQL Trace Tool

BC170_2.15.2

Objectives

• The participants will be able to:

– Use the SQL Trace Tool in SAP

– Analyze an SQL Trace

BC170_2.15.3

Using the SQL Trace Tool (ST05)

Query Under Investigation :

. . .
Select * from KNA1, KNB1
Where KNA1.KUNNR =
KNB1.KUNNR
. . .

BC170_2.15.4

How Do I Turn Trace On and Off?

BC170_2.15.5

Analyzing the SQL Trace

BC170_2.15.6

Display Execution Plan

SQL

Query

Execution

Plan

BC170_2.15.7

Summary

• The participants should be able to:

– Use the SQL Trace Tool in SAP

– Analyze an SQL Trace