What Oracle OPTIMIZER_MODE is used with TIBCO InConcert Oracle 10i?
book
Article ID: KB0088571
calendar_today
Updated On:
Products
Versions
TIBCO InConcert
-
Not Applicable
-
Description
Resolution: Description: The Oracle Optimizer mode is used to tell Oracle what type of strategy to use in providing the results. Previous versions of InConcert used RULE mode when working with Oracle versions 9i and below.
Environment: All
Resolution:
InConcert uses OPTIMIZER_MODE = FIRST_ROWS_1000 for Oracle 10i and up.
Issue/Introduction
What Oracle OPTIMIZER_MODE is used with TIBCO InConcert Oracle 10i?