Skip to Content
Former Member
Apr 17, 2014 at 12:29 PM

Bad Performance on Sybase ASE


Hi experts,

we are planning to doing a migration from Oracle to Sybase ASE.

At the moment we are having one productive ERP System on Oracle and one testing system on sybase ASE.

If I do an select on the same table in Q and P, I have a big time difference.

Which means, in Q-System it is very slow.

At the moment I am trying to analyze the sybase, what is causig this problem.

Can some provide me some tips.

At the moment I am fighting with ST12.

If I make an explain in ST12, I get the message "No matching plan cound be found in the procedure cache - use Runtime Explain".

What does it mean or were can I check the execution plan for sybase ASE?

Thank you