db2_evaluncommitted , db2_skipinserted and db2_skipdeleted

[stepaq]

Hi

I was wandering if someone has seen a bad side of using one of these
parameters ?
Amy performance problem ?

Since with db2_evaluncommitted, db2 evaluates the where clause before
locking, I was thinking that may cause a performance degradation.

thanks
Stephane

[Serge Rielau]

stepaq wrote:

Hi

I was wandering if someone has seen a bad side of using one of these
parameters ?
Amy performance problem ?

Since with db2_evaluncommitted, db2 evaluates the where clause before
locking, I was thinking that may cause a performance degradation.

Stephane the WHERE clause has to be evaluated one way or another.
Note that this only applies to predicates in the WHERE clause that can
be pushed down that far (aka. Sargable or Type 2 predicates).

I have a hard time imagining a performance downside for any of those.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab