Articles & Content

Archives

DB2 EXPLAIN Explained (C14)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-15 (10:30 AM - 11:30 AM)
SPEAKERS: Bonnie Baker (Bonnie Baker Corporation)

Our PLAN_TABLE now has many siblings and EXPLAIN now offers exponentially more information. This session will cover some of the ways you can use this new information to design you indexes and tune your SQL. It will also cover some of the less well-known facts about EXPLAIN information

EXP. LEVEL: Intermediate

OBJECTIVES:

Information about Index SCREENING as well as Index MATCHING

Stage 2 Predicates now identified by EXPLAIN

Help in understanding new Access Paths

Index-only deletes

Multiple index access - the good and the bad plus alternative SQL



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.