Lack of Index on TENDER_COLLAB_SERVPROV Causes Service Provider Queries to do a Full Table Scan
(Doc ID 737670.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Transportation Management - Version 5.5 to 5.5 [Release 5.5]
Information in this document applies to any platform.
This problem can occur on any platform.
-- Problem Statement:
On 5.5.04, Find that when any service provider, attached with the default SERVPROV VPD profile, runs any query involving shipments, there is a full table scan on the tender_collab_servprov since that table is referred to in the VPD
Expect that the full table scan is avoided by adding an index
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log on as a Service Provider and run the query on Shipment records
2. Capture the execution plan for such a query and see that there is a full table scan on the
Due to this issue, general performance is affected for Service Provider users
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document