TAdams
Member
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
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