|
|
|
|
|
used_pgs( object_id, doampg, ioampg )
Returns the number of pages used by a table and its clustered index.
Example
select Object_Name(Id), IndId, Name, Used_pgs( Id, doampg, ioampg )
from sysindexes
where Id in (Object_Id('T_Feature'), Object_Id('T_ProdBillOfMat'))
and IndId < 2