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

点击(此处)折叠或打开

1. select a.name as tabname
   
2. ,h.name as idname
   
3. ,rr.row_num as rownum
   
4. from sys.objects as a
   
5. right join sys.indexes as h
   
6. on a.object_id=h.object_id
   
7. join ( select a.name as tbname,max(b.rows) as row_num
   
8. from sysobjects a ,sysindexes b
   
9. where a.id=b.id and a.xtype='u' and a.name like 'TRP%'
   
10. group by a.name
    
11. ) rr
    
12. on a.name=rr.tbname
    
13. where a.type<>'s' and a.name like 'TRP%' and rr.row_num>1000000
    
14. order by rr.row_num desc
    
15. go