Re: OW Co-existence and SQL indices

[TAdams]

Re: OW Co-existence and SQL indices

Gordon,
I agree, you also may want to look at the file descriptions to see if the indices are being shared. If not then you may want to delete them, however you should setup test scenarios to ensure that the opimizer will select the index from the 'world logical' and not have to build one on the fly.

As a follow on to this, has anyone out there needed to add custom indices? We added several to Sales Order detail and Sales order history after suffering severe response time issues with order entry. These were suggested by IBM support after running and analyzing the AS/400 Database Monitor tool.

Tim Adams

B7332, SP 11.2 AS/400 V4R4 SQL 7.0


>>Gordon,
>> Not sure if i am remembering correctly but i thought that logicals with the same keys shared the same access path by default >> on the AS400 and therefore would not cause any additional overhead. (IMHO) i would be hesitant to delete any logicals
>> created by One World.
>>dave

 

[Seano]

Re: OW Co-existence and SQL indices

Gordon,

I'm not so sure that you should delete the OW indices. In Oracle, they are
sequentially numbered. In World, they were labelled alphabetically.

I'm sure they've followed the same naming conventions for co-existence?

To delete an index will not resolve your problem, instead, you'll have lost
an object (obviously how OW views ALL components).

It's is true in OS/400 terms that "the best path" will be used for file
access, but an index is an object and will be specifically referenced in the
UBE's.

Seano.
B7332, HP9000, Oracle.
Ex. World.





>From: TAdams <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: Re: OW Co-existence and SQL indices ~~0:5218
>Date: Wed, 7 Feb 2001 12:32:43 -0800 (PST)
>
>Gordon,
>I agree, you also may want to look at the file descriptions to see if the
>indices are being shared. If not then you may want to delete them, however
>you should setup test scenarios to ensure that the opimizer will select the
>index from the 'world logical' and not have to build one on the fly.
>
>As a follow on to this, has anyone out there needed to add custom indices?
>We added several to Sales Order detail and Sales order history after
>suffering severe response time issues with order entry. These were
>suggested by IBM support after running and analyzing the AS/400 Database
>Monitor tool.
>
>Tim Adams
>
>B7332, SP 11.2 AS/400 V4R4 SQL 7.0
>
>
> >>Gordon,
> >> Not sure if i am remembering correctly but i thought that logicals
>with the same keys shared the same access path by default >> on the AS400
>and therefore would not cause any additional overhead. (IMHO) i would be
>hesitant to delete any logicals
> >> created by One World.
> >>dave
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> !
>!
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=5218
>*************************************************************
>This is the JDEList One World / XE Developers Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.