Skip to Content
0
Former Member
May 05, 2015 at 01:54 PM

Bad performance on table access - how to analyze?

712 Views

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