Bad performance on table access - how to analyze?
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.
Anon 123 replied
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.