Articles & Content

Archives

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

Topic: 2011 NA

Subtopic: DB2 for z/OS



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

OBJECTIVES:

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



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.