Calcolare pesantezza Tabelle sql




 SELECT SYS_OBJ.NAME AS "TABLE NAME"

     , SYS_INDX.ROWCNT AS "ROW COUNT"

FROM SYSOBJECTS SYS_OBJ, SYSINDEXES SYS_INDX



WHERE SYS_INDX.ID = SYS_OBJ.ID

  AND INDID IN(0,1)

  AND XTYPE = 'U'

 AND SYS_OBJ.NAME <> 'SYSDIAGRAMS'



ORDER BY SYS_INDX.rowcnt DESC

COMPUTE SUM(SYS_INDX.ROWCNT)