DB2 for z/OS

SQL Search and Scroll Techniques in DB2 for z/OS (F14) 

May 06, 2011 03:00 PM

DATE: 2011-5-6 (09:15 AM - 10:15 AM)
SPEAKERS: Daniel Luksetich (YL&A)

This presentation will address the many different ways you can search of data in DB2 for z/OS. It's concentration will be on table and index design to support searching and scrolling, as well as various SQL coding techniques for search capabilities and indexing. We will focus significantly on performance of queries while trying to keep the number of indexes to a minimum. It will also look at the basic and advanced scroll techniques and choices for performance from a practical coding perspective based upon real-world experience.

EXP. LEVEL: Beginner,Intermediate,Advanced


Discuss DB2 features that support searching and scrolling

discuss database and indexes design, including extreme design and performance tricks

Demonstrate the choices for matching on index columns for search queries

Discuss DB2 merge versus materialization and predicate transitive closure

Demonstrate possible program solutions for scrolling of multi-table queries

pdf file
NA11F14.pdf   4.35 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.