Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

To create/manage indexes of a table, it is important to know the ratio insert/select or modification/reporting. For instance, if there are more INSERTS than SELECT against a table, we should try to create only a few small indexes not to impact the INSERT performance.

How to calculate this ratio in Sybase ASE 15.5 and later?

Does it make sense to run the following?

select "Table"=object_name(ObjectID), IndexID, PagesRead, PagesWritten, Operations
from master..monOpenObjectActivity
where DBID=db_id("DBNAME") and ObjectID=object_id('TableNAME')
order by IndexID
share|improve this question
did this method work for you? – Max Vernon Sep 5 '14 at 2:16
Actually I did not get the chance to proceed further but I realized that this SQL only catches information for the last few minutes (depending on the MDA pipe size). So to get relevant information, I think we should calculate delta values for monOpenObjectActivity since the previous call in a session. See perfect SP described in – Vince Sep 8 '14 at 19:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.