Serge Rielau wrote:

> Ken,
>
> Have you compared the explains (best db2exfmt) for the two queries?
> This should be the starting point.
>
> Cheers
> Serge
>
In looking at the exlplains for both, the optimized statment is the
same. Bufferpools match, optimization plan is the same, everything looks
ok. I don't see anything there out of wack. Just slower. The cost on 8.2
is 32458 compared to 78334 on 7.1, so shouldn't 7.1 be slower? CPU speed
is also slower on the 7.1 database. (The 8.2 database is a 4-way PWR5
AIX machine, the 7.1 database is a 4-way pwr3 machine, I run all the
statments from db2adm on the repective machine)


Is there anything special to look for in there.

Ken