You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a way to request additional indexes to Oracle Fusion seeded tables like?

in Reporting & Analytics for Fusion Service

Hello,

we have a huge custom datamodel for the invoice print receivables process. After analysing the execution plan (provided by Oracle support for the main dataset) we found out that one of the bottle necks in the the query is a join to a doo table (DOO_FULFILL_LINE_DETAILS) using an unindex field.

So simple question is, if there is a way to add or request addition indexes at all to seeded tables? And if so what are possible consequences of requesting this what needs to be thought of.

It would be really interesting to know if this is a valid scenario and option to go for. So please just let me know. And yes, I know there might be other options as well which we are considering to improve query performance but I want to know if adding new indexes could be one of them.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!