What Oracle OPTIMIZER_MODE is used with TIBCO InConcert Oracle 10i?

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?