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
  • 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 http://www.sypron.nl/mda.html
    – Vince
    Commented Sep 8, 2014 at 19:22


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.