DatabaseTableApplicationCreatedLinks
tempdb#indexData_crby_sybsystemprocs__sp_spaceusage_object_populate  01 Jan 70Joins Schema ColumnUsage Queries Dependencies

1     create table #indexData(-- 0 Rows, Data: 0 B, Index: 0 B
2         id unknown not null,
3         indid unknown not null,
4         ptnid unknown not null,
5         name unknown not null,
6         type varchar(0) not null,
7         indexlevel int not null,
8         ffactor smallint not null,
9         maxrowsperpage smallint not null,
10        datalayerpages int not null,
11        numrows float not null,
12        leafrowsize float not null,
13        nonleafrowsize float not null,
14        lockscheme tinyint not null,
15        numofdatapages int not null,
16        datasizeinkb float not null,
17        numofusedpages int not null,
18        usedsizeinkb float not null
19    )
20    
21    
22    create unique index uind on #indexData_crby_sybsystemprocs__sp_spaceusage_object_populate(-- 0 B refcount: 6
23        id DESC, indid DESC, ptnid DESC, indexlevel DESC
24    )
25    
Estimated Index Usage
#indexData.uind unique(id, indid, ptnid, indexlevel)6

COLUMN USAGE
idsp_spaceusage_object_populate 
indidsp_spaceusage_object_populate 
ptnidsp_spaceusage_object_populate 
indexlevelsp_spaceusage_object_populate 
datalayerpagessp_spaceusage_object_populate 
numrowssp_spaceusage_object_populate 
leafrowsizesp_spaceusage_object_populate 
nonleafrowsizesp_spaceusage_object_populate 
lockschemesp_spaceusage_object_populate 
numofdatapagessp_spaceusage_object_populate 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_spaceusage_object_populate  
   called by proc sybsystemprocs..sp_spaceusage_object  
      called by proc sybsystemprocs..sp_spaceusage