Skip to Content
Former Member
Aug 02, 2013 at 05:11 PM

How to identify in sybase 15.7 sql which is doing expensive tablescans?


I was able to identify which table has many tablescans using Rob Verschoor tool sp_mda_monOpenObjectActivity, but the table is used in 100s stored procedures and has several triggers, how to make next step and see which SQL with this table makes a lot of tablescans?