dba_fla@yahoo.com (Sean C.) wrote in message news:<2f9c2d92.0402061427.6b094825@posting.google. com>...

> I've included the output of both explains below.
> Can anyone shed some light on this? Would a different index
> arrangement improve this situation such that the optimizer would not
> make such poor choices?

db2exfmt of the problem query would give much more detail, including
cardinality estimates at each step, which might help us see better
what DB2 thinks it's doing.


DG