DatabaseTableApplicationCreatedLinks
mastersysusages  31 Aug 14Joins 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
From ColumnsTo TableTo ColumnsCntCstrStrength
[vdevno]master..sysdevices[vdevno]60 Simple Join
[dbid]master..sysdatabases[dbid]18 FK

Estimated Index Usage
sysusages.csysusages unique clustered(dbid, lstart)49
sysusages.ncsysusages unique(vdevno, vstart)32

ALIASES USED for master..sysusages
NO_ALIASbsusysusagesu
1541728

SCHEMA

COLUMN USAGE
dbidsp_addsegment  sp_addthreshold  sp_databases  sp_ddlgen_database  sp_dropdevice  sp_dropsegment  sp_extendsegment  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment  sp_logdevice  sp_modifythreshold  sp_odbc_databases  sp_plan_dbccdb  sp_spaceusage_tranlog_init  sp_spaceused 
segmapsp_addsegment  sp_addthreshold  sp_ddlgen_database  sp_dropsegment  sp_extendsegment  sp_helpdb  sp_helplog  sp_helpsegment  sp_logdevice  sp_modifythreshold  sp_spaceusage_tranlog_init  sp_spaceused 
lstartsp_addthreshold  sp_ddlgen_database  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment 
sizesp_addthreshold  sp_databases  sp_ddlgen_database  sp_dropdevice  sp_dropsegment  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment  sp_modifythreshold  sp_odbc_databases  sp_plan_dbccdb  sp_spaceusage_tranlog_init  sp_spaceused 
vstartsp_addsegment  sp_extendsegment  sp_helpdb  sp_helpdevice 
locationsp_helpdb 
unreservedpgssp_addthreshold  sp_helpdb  sp_helpsegment  sp_spaceused 
crdatesp_ddlgen_database  sp_helpdb  sp_helpdevice 
vdevnosp_addsegment  sp_ddlgen_database  sp_dropdevice  sp_dropsegment  sp_extendsegment  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment  sp_logdevice  sp_plan_dbccdb  sp_spaceused 

QUERIES
Joined With Links
master..sysdevices sybsystemprocs..sp_extendsegment:165
sybsystemprocs..sp_dropsegment:498
sybsystemprocs..sp_logdevice:208
sybsystemprocs..sp_helplog:40
sybsystemprocs..sp_extendsegment:182
sybsystemprocs..sp_helpsegment:151
sybsystemprocs..sp_addsegment:184
sybsystemprocs..sp_extendsegment:337
sybsystemprocs..sp_extendsegment:382
sybsystemprocs..sp_dropsegment:489
sybsystemprocs..sp_helpsegment:110
sybsystemprocs..sp_addsegment:171
sybsystemprocs..sp_logdevice:174
sybsystemprocs..sp_dropsegment:301
sybsystemprocs..sp_extendsegment:355
sybsystemprocs..sp_dropsegment:395
sybsystemprocs..sp_addsegment:334
sybsystemprocs..sp_dropsegment:282
sybsystemprocs..sp_logdevice:157
sybsystemprocs..sp_addsegment:222
sybsystemprocs..sp_dropsegment:320
sybsystemprocs..sp_logdevice:198
sybsystemprocs..sp_addsegment:154
sybsystemprocs..sp_dropsegment:375
master..sysdatabases master..sysdevices sybsystemprocs..sp_dropdevice:107
sybsystemprocs..sp_dropdevice:86
sybsystemprocs..sp_plan_dbccdb:111
sybsystemprocs..sp_ddlgen_database:330
sybsystemprocs..sp_dropdevice:96
sybsystemprocs..sp_dropdevice:71
master..sysdatabases sybsystemprocs..sp_helpdb:739
sybsystemprocs..sp_odbc_databases:35
sybsystemprocs..sp_databases:23

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