Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SAP Learning

A First Step Towards SAP HANA Query Optimization

via SAP Learning

Go to class Write review
Corporate Finance Institute Ad

Finance Certifications Goldman Sachs and Amazon Teams Trust

Learn More → Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates

This course focuses on optimizing query performance in SAP HANA. It covers analyzing and solving out-of-memory issues, understanding SQL processing, learning about the SAP HANA SQL optimizer, and improving SQL performance with SAP HANA-specific features. The course also explores performance analysis tools and includes demos and case studies.

Syllabus

  • SAP HANA Query Processing
    • Course Introduction
    • SQL Query Processing in SAP HANA
    • SQL Queries – Order of Execution
    • Hands-On: Simple Query Execution
    • SQL Optimizer – Architectural Overview
    • Parameter-Aware Optimization
    • Hands-On: Understand Parameter-Aware Optimization
    • Downloads
    • Assignment Week 1
  • Column Search and Analysis Tools
    • Column Search
    • SQL Trace
    • Explain Plan
    • Visualized Plan
    • Trace for Parameterized Query
    • Column Searches in the Traces
    • How to Analyze Out of Memory (OOM) Dumps
    • Downloads
    • Assignment Week 2
  • Methods for Query Performance Analysis
    • Query Analysis – Overview
    • Concepts of Dominant Operators and Possible Key Reducers
    • Techniques Using Dominant Operators and Possible Key Reducers – 1
    • Techniques Using Dominant Operators and Possible Key Reducers – 2
    • Hands-On: Simple Query Performance Analysis 
    • SQL Tuning Tip – 1
    • SQL Tuning Tip – 2
    • Downloads
    • Assignment Week 3
  • Case Studies
    • Case 1 – Sporadic Composite OOM
    • Case 1 – Plan Comparison and Analysis
    • Case 1 – Issue Conclusion
    • Case 2 – Find Dominant Operator and Possible Key Reducer
    • Case 2 – Finding SQL Hint
    • Case 2 – Simulating the Query Processing with SQL Hint
    • Case 2 – Applying the Solution
    • Downloads
    • Assignment Week 4

Reviews

Start your review of A First Step Towards SAP HANA Query Optimization

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.