Prev: Any body could help me out on DB2 stored procedure on Z/OS
Next: Product / license for z/OS Universal Driver on clients
From: stepaq on 9 Jan 2008 16:08
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
From: Serge Rielau on 10 Jan 2008 06:32
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
 | 
Pages: 1
Prev: Any body could help me out on DB2 stored procedure on Z/OS
Next: Product / license for z/OS Universal Driver on clients