John Hornibrook

Speaker Details

Bio

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of DB2 for Linux, UNIX and Windows, dashDB and the Big SQL feature of Big Insights. John also works closely with customers to help them maximize their benefits from IBM's relational DB technology products.

Past presentation
11 April 2017
11:45 - 12:45
SQLAdria Seminar – Ljubljana 2017 DB2 11.1. – A Query Optimizer Perspective

DB2 11.1 and 11.1.1.1 provide a number of new features to extend DB2 capability and provide improved performance. Leading the list is BLU Acceleration in a massively parallel processing (MPP) configuration, which allows DB2's leading edge compressed column-organized table support to run across multiple servers to provide the ability to support databases that are hundreds of terabytes in size. Additionally, a number of improvements have been made to BLU join, sort, correlated subquery and analytic function processing to provide even better performance in all BLU configurations. This presentation will help you understand how BLU technology works, what has changed in DB2 11.1/11.1.1.1 and the role of the query optimizer in achieving industry-leading performance.


11 April 2017
10:30 - 11:30
SQLAdria Seminar – Ljubljana 2017 Vita Statistic – What You Should Know About DB2 for Linux, UNIX and Windows Catalog Statistics

The DB2 for Linux, UNIX and Windows query optimizer is responsible for choosing optimal query access plans, however it can't do its job properly without vital information about your data and database objects. The RUNSTATS utility has been used for years by database administrators to collect these statistics and store them in the system catalog tables. However, statistics collection has significantly evolved since RUNSTATS was first introduced. DB2 has a rich set of statistics to help the optimizer understand complex relationships in your data and across your tables. Statistics can be collected automatically and even at query optimization time. This presentation will provide an overview of DB2 catalog statistics and the options to collect them, to help you achieve optimal query performance, with minimal administration effort.


 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2024

VODICE -  10th - 13th June 2024