Articles & Content
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
Nested Loop Join
Merge Scan 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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.