Serge Rielau wrote:

> 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
>
I am appreciating all the help.
It seems with all the table re-orgs and index re-orgs I've done now (I
didn't realize indexes are no longer done automatically in 8, so I did
them now) that my posstr method is down to .35 seconds. The %STRING%
method is still 11.7 seconds.
0.35, I'm very happy. But still wondering why the like '%STRING%' is
drastically slower on 8.

Ken