Prev: db2 sequence to reset automatically
Next: Database backup cron job consumes large amount of memory
From: Serge Rielau on 4 Jul 2010 22:44
On 7/3/2010 1:58 PM, Henry J. wrote:
> Serge, could it be possible that adding "WITH UR" would slow down a
> merge statement? It's what happened when I added "WITH UR" to a merge
> statement. Hard to tell if the slowness was caused by other factors,
> as this was the only change... Thanks.
Hmmm,...
I don't see why, but get a db2exfmt with and without the clause and compare.
A WITH UR on a subquery I could fathom as restricting what the optimizer
can do, but a "global" WITH UR should have the same effect as setting
the isolation level for the session.



--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

First  |  Prev  | 
Pages: 1 2
Prev: db2 sequence to reset automatically
Next: Database backup cron job consumes large amount of memory