Poor performance on SDV03V02

[Ganimede-Dignan]

Hi,

I'm a ASE newbie and I've just try to migrate our Solaris/Oracle Box to a Windows/ASE Box as a send box.

The source machine has got 7000 saps and target machine has got 25000 saps.

After migration I've implemented several notes to run DBACOCKPIT and I implemented ATM...

At first use the system seams very fast, but when I try to run SDV03V02 (rescheduling) it runs without end for several hours.

Each select on VAPMA and VBUK on target system Windows/ASE run faster then source system Solaris/Oracle.

But SDV03V02 stay hours on:

Have you got any suggest? In Oracle land updated statistics should solve.... but in ASE?

Thank you.

[Ganimede-Dignan · Accepted solution]

Of course... with a custom index is super fast, an index on MANDT, VBELN, GBSTK, RFGSK, LFGSK, LFSTK, COSTA, ABSTK, VBTYP for VBUK table.

But... why is it so dramatically unfavorable ASE compared to Oracle the absence of this index?

Thank you.

Regards.

[Ganimede-Dignan]