when condition in a trigger

Walter Janißen

when condition in a trigger
Hello list

I want to come back to a question, I asked some weeks ago, because I didn't
get any feedback. Maybe I should ask my question in a different way.

Did anybody use triggers with a WHEN-condition in a trigger body and
checked the access path. I always get a tablespace scan on the table on
which I defined the trigger, if I use a transition variable (even for the
simplest condition for example WHEN N.column = constant). If this is really
a ts, it could be horrible. I wonder what DB2 is looking for?

Any feedback would be greatly appreciated, perhaps any IBM'er will reply.