Articles & Content


Explaining Access Paths - Visually (F04)

Topic: DB2 for z/OS

Subtopic: 2006

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

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.