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?