How can I improve the performance of reports and analyses that are based on the Product Management - Structures and Components Real Time subject area?
In reports and analyses that are based on the Product Management - Structures and Components Real Time subject area, to improve the performance when they return the exploded view of a bill of material (BOM) or include Component Assembly Attributes > Reference Designator >
-
Add the following:
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1', DISABLE_CACHE_HIT=1, OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_optimizer_push_pred_cost_based'',''false'') OPT_PARAM(''_complex_view_merging'',''false'')';
-
Add this filter:
("Structure Quick Preview"."Component AML Pending Revision Flag" = 'N')
-
Use the
UPPER()
function with the filter on the item name.