1. Creating and Administering Analytics and Reports for SCM
  2. Improve Query Performance in Analyses for the Order Management - Order Holds Real Time Subject Area

Improve Query Performance in Analyses for the Order Management - Order Holds Real Time Subject Area

Use this procedure to improve query performance for Order Management - Order Holds Real Time subject area queries.

  1. In the Browse Catalog UI, click New > Analysis .

  2. Select Order Holds - Order Management Real Time.

  3. In the Advanced tab, find the Advanced SQL Clauses section.

  4. In the Prefix field, enter this value: SET VARIABLE OBIS_DBFEATURES_IS_LEFT_OUTER_JOIN_SUPPORTED=0,OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='NO_MERGE(@HoldInstancePVO)';

  5. Click Apply SQL.

  6. In the SQL Issued, verify that the hints were prefixed to the logical query.

  7. To review the result changes, use the Results tab.

Note: If the Order Holds subject area is used in a cross-subject area query, you must apply the hint to the Order Holds subject area only.