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 |
QUERIES |
Joined With | Links |