Troubleshoot SQL with SAP HANA Database Explorer
February 23, 2021
Beginner
10 min.
Explore the available tools to help diagnose and debug SQL or SQLScript.
You will learn
- How to debug SQLScript
- How to use code coverage and SQLScript code analysis
- About the tools available to assist in performance analysis (explain plan, SQL Analyzer)
- How to configure and examine traces
Prerequisites
- An SAP HANA database such as SAP HANA Cloud, HANA database trial or the SAP HANA, express edition that includes the SAP HANA database explorer
- You have completed the first 3 tutorials in this group.
Step 1: Debugger
Step 2: Code coverage
Step 3: SQLScript analysis
Step 4: Explain plan
Step 5: SQL Analyzer
Step 6: SQL trace
Step 7: Expensive statements trace