Take the 2-minute tour ×
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.

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 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 sypron.nl/mda.html –  Vince Sep 8 at 19:22

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.