查看TRP开头的数据量超过1000000的表的index情况
点击(此处)折叠或打开
-
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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16131092/viewspace-2150408/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
