A blueprint query used in MUX on views needs optimization. Query beginning:
select
:"SYS_B_00" pmd_analytical_partition_by,
odf_abstract_blueprints.id odf_pk,
odf_blueprints.IS_PRIVATE as is_private,
ODF_ABSTRACT_BLUEPRINTS.CODE as code,
odf_ca_abs_blueprint.odf_period_type as odf_period_type,
odf_ca_abs_blueprint.odf_period_end as odf_period_end,
odf_blueprints.TYPE as type,
odf_ca_abs_blueprint.odf_period_start as odf_period_start,
ODF_BLUEPRINTS.CLASSIFIER as assoc_object,
odf_blueprints.BLUEPRINT_MODE as blueprint_mode
STEPS TO REPRODUCE:
Expected Results: The query to be taking under 0.1 sec or similar since it's called a lot
Actual Results: The query is taking 0.5 seconds. Since the number of executions is high, this can add up
This is DE94909, closed as Cannot Reproduce
If you face the same issue, find exact steps and contact Support