View Printable Version

E10 - SQL Query Writing Tips To Improve Performance in Db2 and Db2 Warehouse on Cloud

Session Number: 5146
Track: Application Development
Session Type: Podium Presentation
Primary Presenter: Calisto Zuzarte [IBM Canada Lab]
Time: May 02, 2018 (09:20 AM - 10:20 AM)
Room: Congress B

Session Code: E10
Speaker Bio: Calisto Zuzarte is a Senior Technical Staff Member (STSM) in the Db2 development organization. His focus area is database query performance. He also represents IBM on the ANSI and ISO SQL Standards committee.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators
Technical areas this presentation will apply to: Data Warehousing and Business Intelligence, Database Performance (DB2 for LUW)
Objective 1: Provide an overview of the automatic query rewrite engine and show how it can take different SQL and yet give optimal performance
Objective 2: Provide examples where some less than optimal SQL constructs could be written in a different way to boost performance
Objective 3: Emphasize scenarios based on customer experiences with column organized tables (BLU)

Abstract:  Data managed by databases has been growing exponentially and the trend has been to push much of the application processing close to the data. Applications often can no longer pull the data to do some processing as part of the application logic. Much of this logic is now expressed as one big SQL statement and executed in the database engine. Complex and sophisticated SQL queries, particularly analytical queries, can be a challenge to database optimizers.

There are many ways to write SQL variations that get the same result. The optimizer has the goal of relieving the user from having to write the perfect version of the SQL statement. The optimizer usually does an outstanding job but there are times when it may not have some knowledge about the data and can do with some help. This session looks at some SQL query writing tips and tricks to improve performance in the dashDB and DB2 database systems.

For questions or concerns about your event registration, please contact support@idug.org