Topics: |
Adapter optimization allows the RDBMS to perform the work for which it is best suited, reducing the volume of RDBMS-to-server communication and improving response time. It also enables the RDBMS to exploit its own internal optimization techniques.
For more information, see Optimizing Requests and Optimizing Requests to Pass Virtual Fields Defined as Constants.
The Redbrick adapter can optimize FOCUS OUTER JOINs to SQL. However, the OUTER JOIN optimization depends on native Redbrick capabilities. Non-equality conditions in ON clauses are supported for INNER JOINS only. For OUTER JOINs, non-equality conditions will return:
RBS1609,..., RBS1612 An outer join <problem criteria>
or
10167 Attempt to initiate a new SQL...with results pending
For more information please refer to IBM Redbrick documentation.
WebFOCUS | |
Feedback |