Analyzing Db2 SQL using Jupyter Notebook

Session Number: 7381
Track: Virtual Event
Session Type: Podium Presentation
Primary Presenter: Ember Crooks [[Confidential]]
Time: Jul 27, 2020 (08:00 AM - 08:05 AM)

Speaker Bio: Ember has 19+ years of experience with Db2 on Linux, Unix, and Windows platforms. She is the founder and principal author of the popular datageek.blog technical blog where she educates herself and others through example and case study. Ember is an IBM Gold Consultant and IBM Champion in Information Management.
Audience experience level: Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), SQL and XML Performance, User Experiences
Objective 1: Learn calculations for key metrics related to SQL performance
Objective 2: Use Jupyter Notebook to identify problem SQL and decide which statements to spend more time on
Objective 3: Use Jupyter Notebook to thoroughly analyze potential indexes before creating them

Abstract:  How do you know if your SQL is performing well? How do you identify poorly performing statements? When SQL isn't performing well, how do you analyze what might work to make things better? Join Ember and learn her strategies for in-depth SQL analysis using Jupyter Notebook. Ember shares her Jupyter Notebooks for this work, including a notebook that can help you analyze Db2's index recommendations to determine which indexes really help.