Performance issues on SQL queries involving Cost Plan Details table

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Post upgrade to 16.4.2 Clarity version, performance issues are being observed on SQL queries that are filtering 'PLAN_ID' on the Cost Plan Details table - 'FIN_COST_PLAN_DETAILS'

STEPS TO REPRODUCE:

1. Access a Clarity 16.4.1 Oracle database based environment and connect to the Clarity PPM database
2. Run the following SQL and note the timing
   • SELECT *
     FROM fin_cost_plan_details
     WHERE plan_id IN (
     5428029,
     5407001,
     5404035
     );
   • (Note: This shall not generate results but shall scan the table)
3. Upgrade this Clarity environment to Clarity 16.4.2 version and connect to the Clarity PPM database
4. Run the same SQL as mentioned on Step 2. Note and compare the timings

 

Expected Results :

For the same dataset, between both the upgraded and lower environment the SQL fetch response time should be similar

Actual Results :-

The response time is observed to be more in the upgraded environment

Environment

Clarity 16.4.2

Cause

DE206977

Resolution

This issue is under review by the Engineering Team