Skip to Content
0
Nov 04, 2019 at 01:51 PM

Fetch FETCH NEXT CURSOR taking long time in pre-prod compared to Prod

461 Views

Hi

We are scheduling a standard program RFKKOP04 in production and pre-production(Data refreshed from production last week).Program is running very slow in pre-prod we have checked all the resources between the systems and they have same capacity.

When i look at ST04 and explain statement,


In pre-Prod : Estimated cost =3,985,263 Estimated CPU cost = 46,538,639,201

In production : Estimated Cost = 840,778 Estimated CPU-Costs = 9,447,973,201

I have checked indexes in both systems they are same.

What else should we check to know the reason for extra time in pre-production?

Thanks for your help.

Cheers,

Anjana