当前位置：首页 > 数据库 > MSSQL教程 > 查看TRP开头的数据量超过1000000的表的index情况 > 正文

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

来源：这里教程网 时间：2026-03-02 11:17:28 作者：

点击(此处)折叠或打开

    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


编辑推荐：

相关推荐

最新软件资讯

SQL SERVER版本补丁体系及升级
SQL SERVER版本补丁体系及升级

热文推荐

天极热推