| 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 |