1 create table sysindexes(-- 6 Rows, Data: 16 KB, Index: 22 KB
2 name longsysname(255) null,
3 id int not null,
4 indid smallint not null,
5 doampg int not null,
6 ioampg int not null,
7 oampgtrips int not null,
8 status3 smallint not null,
9 status2 smallint not null,
10 ipgtrips int not null,
11 first int not null,
12 root int not null,
13 distribution int not null,
14 usagecnt smallint not null,
15 segment smallint not null,
16 status smallint not null,
17 maxrowsperpage smallint not null,
18 minlen smallint not null,
19 maxlen smallint not null,
20 maxirow smallint not null,
21 keycnt smallint not null,
22 keys1 varbinary(255) null,
23 keys2 varbinary(255) null,
24 soid tinyint not null,
25 csid tinyint not null,
26 base_partition int null,
27 fill_factor smallint null,
28 res_page_gap smallint null,
29 exp_rowsize smallint null,
30 keys3 varbinary(255) null,
31 identitygap int null,
32 crdate datetime null,
33 partitiontype smallint null,
34 conditionid int null
35 )
36
37 create unique clustered index csysindexes on sysindexes(-- 6 KB refcount: 177
38 id, indid
39 )
40
41 alter table sysindexes lock datarows
42
43 Grant Select on sysindexes to public
44
Estimated Index Usage |
sysindexes.csysindexes unique clustered(id, indid) | 177 |
ALIASES USED for sybsystemprocs..sysindexes |
NO_ALIAS | i | i1 | i2 | s | si | sysindexes | x |
66 | 39 | 2 | 3 | 4 | 2 | 16 | 14 |
SCHEMA |
 |