您的位置: 首页 > 文章 > 查看TRP开头的数据量超过1000000的表的index情况

查看TRP开头的数据量超过1000000的表的index情况

分类: 文章 • 2022-07-03 20:51:19

点击(此处)折叠或打开

select a.name as tabname
,h.name as idname
,rr.row_num as rownum
from sys.objects as a
right join sys.indexes as h
on a.object_id=h.object_id
join ( select a.name as tbname,max(b.rows) as row_num
from sysobjects a ,sysindexes b
where a.id=b.id and a.xtype='u' and a.name like 'TRP%'
group by a.name
) rr
on a.name=rr.tbname
where a.type<>'s' and a.name like 'TRP%' and rr.row_num>1000000
order by rr.row_num desc
go