1 create table sysdevices(-- 6 Rows, Data: 2 KB, Index: 6 KB
2 low int not null,
3 high int not null,
4 status smallint not null,
5 cntrltype smallint not null,
6 name sysname not null,
7 phyname varchar(127) not null,
8 mirrorname varchar(127) null,
9 vdevno int not null,
10 crdate datetime null,
11 resizedate datetime null,
12 status2 int not null
13 )
14
15 create unique clustered index csysdevices on sysdevices(-- 2 KB refcount: 52
16 name
17 )
18 create index ncsysdevices on sysdevices(-- 2 KB refcount: 30
19 vdevno
20 )
21
22 alter table sysdevices lock datarows
23
24 Grant Select on sysdevices to public
25
Estimated Index Usage |
sysdevices.csysdevices unique clustered(name) | 52 |
sysdevices.ncsysdevices(vdevno) | 30 |
ALIASES USED for master..sysdevices |
NO_ALIAS | c | d | dev | e | sysdevices | v |
26 | 4 | 76 | 1 | 1 | 5 | 2 |
SCHEMA |
|