Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: DB2 Explain

DB2 Explain doesn’t do it for Developers

Published August 2nd, 2011 - by

So there I was running a regular check of PLAN_TABLE in a pre-production environment, checking for any potential poor access paths, when I noticed a new package with a somewhat worrying access path. A tablescan of a 10 million row table with a nasty non-matching index scan, via a nested loop join, of a 20 Continue Reading