SQL Query Processing in SAP HANA - W1U2 - A First Step Towards SAP HANA Query Optimization
A First Step Towards SAP HANA Query Optimization Week_1 Unit 2: SQL Query Processing in SAP HANA
Join this free online course to learn how to analyze query performance issues in SAP HANA and optimize queries yourself, including investigating out-of-memory (OOM) issues deriving from queries and...
Welcome to the first week of A First Step Towards SAP HANA Query Optimization.
This week, the topic is SAP HANA Query Processing, and this is the content you can look forward to:
SAP HANA provides a robust set of techniques for advanced query processing. To fully benefit from the capabilities of SAP HANA, the first step is to optimize your queries.
For better performance, it’s also important to understand the characteristics of SAP HANA and the techniques that can be applied to improve the execution time, as well as the analysis tools you can use to investigate query performance issues.
In this course, you’ll learn how to analyze query performance issues in SAP HANA and optimize queries yourself, including investigating out-of-memory (OOM) issues deriving from queries and finding solutions to improve execution time.
You’ll discover SQL processing, for example, how SQL queries are processed in SAP HANA, and how the SAP HANA SQL optimizer works.
This course also contains techniques and insights that can be applied to improve SQL performance after introducing SAP HANA-specific features such as column search. You’ll also explore the tools that can be used for performance analysis, such as various monitoring views, EXPLAIN PLAN, and PlanViz.
At the end of the course, you’ll work on case studies that illustrate some of the key points.
The course includes demos to highlight key aspects and hands-on exercises to reinforce learning points.
Here is what some participants are saying about the course:
Week 1: SAP HANA Query Processing
Week 2: Column Search and Analysis Tools
Week 3: Methods for Query Performance Analysis
Week 4: Case Studies
Week 5: Final Exam
If your primary interest in taking this course is getting an overview about SAP HANA Query Optimization, you don’t need access to a hands-on system.
However, we will also offer optional hands-on exercises so you can better familiarize yourself with query processing and query optimization in SAP HANA.
For these exercises, you can use a system image from the SAP Cloud Appliance Library. We will provide details on how to access the system image and the costs at the beginning of the course.
SukHyun An is an SAP HANA database product senior specialist with the SQL Performance Consulting Team.
SukHyun designs, develops, and publishes technical information such as the SAP HANA Performance Guide for Developers, SAP Notes, and training courses on SAP HANA SQL performance. Together with other SAP colleagues, he also solves query performance issues for customers.
Follow SukHyun on LinkedIn
Don't Forget to Subscribe for new videos: https://bit.ly/OpenSap
----------------------------
Keys:
Plan Cache - how do we leverage this?,English closed captioning,HANA version and Service pack ?,In hana cache shared between users and sessions?,Plan Cache for Multiple users,Accent Neutraliation ,Row Store Engine vs Column Store Engines,Hash Key and Plan Cache,Plan cache Identifiers - statement_string and Statement_hash
