Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bad performance on table access - how to analyze?

Hi experts,

I am new on Sybase ASE with a just a bit of experience.

We have the problem, that on accessing table COEP we have a very very bad performance since a few days.

The days before it was good with the same read-logic.

We have one index including mandt, objnr and TIMESTMP.

We read with mandt and objnr.

If I analyze with st12 I also can see that the index is used.

I've already checked statistics and did rebuild the index.

however performance is still very very bad.

Does anybody know, what I can do next?

COEP is very big, around 95 MIO entries.

I tried index-check in dbacockpit, but got a connection timeout.

Thx for any ideas.

Kind regards


I already got the answer. Performance impact is to big for that table and therefore I will do it on the weekend.
fyi, -> durring indexing also not insert can be done on the table !!!

BTW, So I did create a new index without the timestamp which solves the performance impact.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question