Articles & Content


Explaining Access Paths - Visually (F04)

Topic: 2006 NA

Subtopic: DB2 for z/OS

DATE: 2006-5-9 (08:30 AM - 09:40 AM)
SPEAKERS: Chris Straub (Highmark Blue Cross/Blue Shield)

Ever wonder what a table space scan actually looks like? What about a merge scan join? How about multiple index access? Or a non-matching index scan?We've all heard the DBA's mention these terms and we've seen them in our Explain, but have you ever wondered what they actually look like? This presentation gives a detailed graphical depiction and explanation of these and many other DB2 access related terms.

EXP. LEVEL: Intermediate


Table Space Scan

Index Scans

Nested Loop Join

Merge Scan Join

Hybrid Join

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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