1 create table sysconfigures(-- 0 Rows, Data: 0 B, Index: 0 B
2 config smallint not null,
3 value int not null,
4 comment varchar(255) not null,
5 status int not null,
6 name varchar(255) null,
7 parent smallint null,
8 value2 varchar(255) null,
9 value3 int null,
10 value4 int null
11 )
12
13 create unique clustered index csysconfigures on sysconfigures(-- 14 KB refcount: 75
14 name, parent, config
15 )
16 create index nc1sysconfigures on sysconfigures(-- 6 KB refcount: 8
17 parent, config
18 )
19 create index nc2sysconfigures on sysconfigures(-- 4 KB refcount: 87
20 config
21 )
22
23 alter table sysconfigures lock datarows
24
25 Grant Select on sysconfigures to public
26
Estimated Index Usage |
sysconfigures.nc2sysconfigures(config) | 87 |
sysconfigures.csysconfigures unique clustered(name, parent, config) | 75 |
sysconfigures.nc1sysconfigures(parent, config) | 8 |
ALIASES USED for master..sysconfigures |
NO_ALIAS | a | b | c | cf | co | con | conf | i | s | sc | sysconfigures |
98 | 8 | 12 | 1 | 2 | 12 | 2 | 1 | 1 | 1 | 3 | 20 |
SCHEMA |
|