73blazer wrote:
> Mark A wrote:
>
>> "73blazer" <yoyo@ma.com> wrote in message
>> news:buCdnWpUP7Mhc8PfRVn-sw@centurytel.net...
>>
>>> I've done the runstats and reorg. The tablespace attributes are the
>>> same. Bufferpools are exactly the same. indexing is the same.
>>>
>>> Ken
>>
>>
>>
>> I will assume you did the reorg first, then the runstats. Reorg and
>> runstats syntax is different between V7 and V8, so make sure you check
>> the syntax and make sure you reorg the indexes also (they
>> automatically get reorged in version 7).
>>
> Thanks for the suggestions. Yes reorg then runstat.
> I did the re-org on indexes explicitly. It wasn't done before, I didn't
> know it wasn't automatically done in 8.2.
> But, it didn't help. All times I give are average of 5 times run, the
> avg time went up by 0.1 seconds. Still in the 14 seconds range.
Can you post the two plans?

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab