Rule based optimization in Oracle Apps

Explain rule based optimization in Oracle Apps

More than a decade ago, all Oracle databases used what is now called rule-based optimization, which uses a fixed strategy to optimize a query's results.
For example, if a table had a unique index and the columns were fully qualified, the table would become the driving table for the rest of the query--regardless of the number of rows in each table.
Profile option “Node Trust Level
If this profile option is set to some external value against a server, then it signifies that the specific middle tier is External......
Profile option “Responsibility Trust Level”
The main significance of Responsibility Trust Level is to make a responsibility accessible from an external web tier.....
Role of Document Manager
To receive pipeline signal from the application on made request. Document Manager Functionality comes within Oracle Universal Content Management (UCM).......
Post your comment