Database | Table | Application | Created | Links |
master | sysusages | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysusages(-- 0 Rows, Data: 0 B, Index: 0 B 2 dbid smallint not null, 3 segmap int not null, 4 lstart int not null, 5 size int not null, 6 vstart int not null, 7 location smallint null, 8 unreservedpgs int null, 9 crdate datetime null, 10 vdevno int not null 11 ) 12 13 create unique clustered index csysusages on sysusages(-- 2 KB refcount: 49 14 dbid, lstart 15 ) 16 create unique index ncsysusages on sysusages(-- 2 KB refcount: 32 17 vdevno, vstart 18 ) 19 20 alter table sysusages lock datarows 21 22 Grant Select on sysusages to public 23
JOINS | ||||||||||||||||||
|
Estimated Index Usage | |
sysusages.csysusages unique clustered(dbid, lstart) | 49 |
sysusages.ncsysusages unique(vdevno, vstart) | 32 |
ALIASES USED for master..sysusages | ||||
NO_ALIAS | b | su | sysusages | u |
15 | 4 | 1 | 7 | 28 |
SCHEMA |
DEPENDENCIES |
READERS AND WRITERS read by proc sybsystemprocs..sp_plan_dbccdb read_written by proc sybsystemprocs..sp_extendsegment read by proc sybsystemprocs..sp_odbc_databases read by proc sybsystemprocs..sp_databases read by proc sybsystemprocs..sp_ddlgen_database read by proc sybsystemprocs..sp_modifythreshold read by proc sybsystemprocs..sp_spaceused read by proc sybsystemprocs..sp_dropdevice read by proc sybsystemprocs..sp_spaceusage_tranlog_init called by proc sybsystemprocs..sp_spaceusage_tranlog called by proc sybsystemprocs..sp_spaceusage read by proc sybsystemprocs..sp_addthreshold read by proc sybsystemprocs..sp_helpdb read_written by proc sybsystemprocs..sp_addsegment read by proc sybsystemprocs..sp_helpdevice read by proc sybsystemprocs..sp_helpsegment read_written by proc sybsystemprocs..sp_dropsegment read_written by proc sybsystemprocs..sp_logdevice read by proc sybsystemprocs..sp_helplog |