-
展示上一张Linux 6系统中Sybase 15.7的热点表安装及服务创建步骤
资源介绍
显示前30张热点表
select top 30 ObjectName, PhysicalWrites, UsedCount
from master..monOpenObjectActivity
where DBID=db_id('hblt_oltp')
and IndexID=0
Order by PhysicalWrites desc
显示前30张热点表中未使用的索引
select top 30 ObjectID into #t1
from master..monOpenObjectActivity
where DBID=db_id('hblt_oltp')
and IndexID=0
Order by PhysicalWrites desc
use hblt_oltp
select convert(varchar,object_name(ObjectID )), convert(varchar,ObjectName)
from master..monOpenObjectActivity
where DBID=db_id('hblt_oltp') and
IndexID!=0 and UsedCount=0
And ObjectID in ( select ObjectID from #t1 )
drop table #t1