DatabaseTableApplicationCreatedLinks
mastersysconfigures  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

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    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[config]master..syscurconfigs[config]40 Simple Join
[config, name]master..syscurconfigs[config, comment]12 Simple Join

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

SCHEMA

COLUMN USAGE
configsp_add_resource_limit  sp_aux_encr_verify_downgrade  sp_bindcache  sp_cacheconfig  sp_chklangparam  sp_compatmode  sp_configure  sp_countmetadata  sp_default_charset  sp_do_poolconfig  sp_helpcache  sp_helpconfig  sp_helpserver  sp_ijdbc_default_charset  sp_ijdbc_getxacoordinator  sp_ijdbc_mda  sp_logiosize  sp_monitorconfig  sp_monitor_crt_mon_config  sp_monitor_getcfgnum  sp_monitor_getcfgval  sp_monitor_list  sp_monitor_list_montypes  sp_opt_querystats_main  sp_setlockpromote  sp_shmdumpdisp  sp_shmdumpsize  sp_sysmon  sp_sysmon_collect  sp_sysmon_dcachestats  sp_unbindcache_all  sp_validateconfigname 
valuesp_aux_encr_verify_downgrade  sp_cacheconfig  sp_chklangparam  sp_compatmode  sp_configure  sp_default_charset  sp_displaylogin  sp_displayroles  sp_do_poolconfig  sp_drv_getsortorder  sp_helpcache  sp_helpconfig  sp_helpjava  sp_ijdbc_default_charset  sp_ijdbc_getxacoordinator  sp_ijdbc_mda  sp_ldapadmin  sp_monitor_crt_mon_config  sp_monitor_getcfgval  sp_monitor_list  sp_monitor_list_montypes  sp_setlockpromote  sp_shmdumpconfig  sp_shmdumpdisp  sp_spaceusage_object_populate  sp_sysmon  sp_sysmon_dcache_sum  sp_validateconfigname 
commentsp_cacheconfig  sp_do_poolconfig  sp_ijdbc_getxacoordinator  sp_opt_querystats_main  sp_spaceusage_object_populate  sp_sysmon  sp_sysmon_dcachestats  sp_sysmon_dcache_sum 
statussp_aux_encr_verify_downgrade  sp_bindcache  sp_cacheconfig  sp_configure  sp_downgrade  sp_do_poolconfig  sp_helpcache  sp_sysmon  sp_unbindcache_all 
namesp_add_resource_limit  sp_aux_encr_verify_downgrade  sp_bindcache  sp_cacheconfig  sp_configure  sp_countmetadata  sp_displaylogin  sp_displayroles  sp_downgrade  sp_do_poolconfig  sp_drv_getsortorder  sp_helpcache  sp_helpconfig  sp_helpjava  sp_helpserver  sp_ldapadmin  sp_logiosize  sp_monitorconfig  sp_monitor_crt_mon_config  sp_monitor_getcfgnum  sp_monitor_getcfgval  sp_monitor_list  sp_monitor_list_montypes  sp_shmdumpconfig  sp_shmdumpdisp  sp_shmdumpsize  sp_sysmon  sp_sysmon_dcachestats  sp_unbindcache_all  sp_validateconfigname 
parentsp_aux_encr_verify_downgrade  sp_bindcache  sp_cacheconfig  sp_configure  sp_downgrade  sp_do_poolconfig  sp_helpcache  sp_helpconfig  sp_logiosize  sp_monitor_list  sp_sysmon  sp_sysmon_dcachestats  sp_validateconfigname 
value2sp_aux_encr_verify_downgrade  sp_cacheconfig  sp_configure  sp_do_poolconfig  sp_helpconfig  sp_validateconfigname 
value3sp_cacheconfig  sp_do_poolconfig  sp_helpcache 
value4sp_cacheconfig  sp_do_poolconfig 

QUERIES
Joined With Links
master..syscurconfigs sybsystemprocs..sp_helpserver:430
sybsystemprocs..sp_configure:1634
sybsystemprocs..sp_sysmon_dcachestats:110
sybsystemprocs..sp_configure:1594
sybsystemprocs..sp_helpcache:81
sybsystemprocs..sp_countmetadata:175
sybsystemprocs..sp_monitor_getcfgval:29
sybsystemprocs..sp_helpserver:180
master..syscurconfigs sybsystemprocs..sp_opt_querystats_main:217
sybsystemprocs..sp_configure:446
sybsystemprocs..sp_helpconfig:409
sybsystemprocs..sp_sysmon:744
sybsystemprocs..sp_cacheconfig:309
sybsystemprocs..sp_ijdbc_getxacoordinator:46
sybsystemprocs..sp_shmdumpdisp:856
sybsystemprocs..sp_opt_querystats_main:608
sybsystemprocs..sp_configure:1793
sybsystemprocs..sp_countmetadata:133
sybsystemprocs..sp_shmdumpsize:81
sybsystemprocs..sp_configure:1550
sybsystemprocs..sp_add_resource_limit:613
sybsystemprocs..sp_helpconfig:143
sybsystemprocs..sp_helpconfig:117
sybsystemprocs..sp_sysmon:886

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_crt_mon_config  
   called by proc sybsystemprocs..sp_monitor_enable  
read by proc sybsystemprocs..sp_monitor_list_montypes  
   called by proc sybsystemprocs..sp_monitor_list  
read by proc sybsystemprocs..sp_spaceusage_object_populate  
   called by proc sybsystemprocs..sp_spaceusage_object  
      called by proc sybsystemprocs..sp_spaceusage  
read by proc sybsystemprocs..sp_shmdumpconfig  
read by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_ijdbc_getxacoordinator  
read by proc sybsystemprocs..sp_ijdbc_default_charset  
read by proc sybsystemprocs..sp_monitorconfig  
   called by proc sybsystemprocs..sp_sysmon_mdcache  
      called by proc sybsystemprocs..sp_sysmon_analyze  
         called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_compatmode  
read by proc sybsystemprocs..sp_opt_querystats_main  
   called by proc sybsystemprocs..sp_opt_querystats  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_add_resource_limit  
read by proc sybsystemprocs..sp_validateconfigname  
   called by proc sybsystemprocs..sp_monitorconfig  
   called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_countmetadata  
read by proc sybsystemprocs..sp_logiosize  
read by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_bindcache  
   called by proc sybsystemprocs..sp_unbindcache  
read by proc sybsystemprocs..sp_ldapadmin  
read by proc sybsystemprocs..sp_displayroles  
read by proc sybsystemprocs..sp_displaylogin  
read by proc sybsystemprocs..sp_helpserver  
read by proc sybsystemprocs..sp_shmdumpdisp  
   called by proc sybsystemprocs..sp_shmdumpconfig  
read by proc sybsystemprocs..sp_chklangparam  
   called by proc sybsystemprocs..sp_addlanguage  
read by proc sybsystemprocs..sp_countmetadata  
read by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_setrowlockpromote  
   called by proc sybsystemprocs..sp_setpglockpromote  
read by proc sybsystemprocs..sp_helpjava  
read by proc sybsystemprocs..sp_sysmon_collect  
   called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_ijdbc_mda  
read by proc sybsystemprocs..sp_unbindcache_all  
read by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_configure  
read_written by proc sybsystemprocs..sp_cacheconfig  
   called by proc sybsystemprocs..sp_do_poolconfig  
      called by proc sybsystemprocs..sp_poolconfig  
read by proc sybsystemprocs..sp_sysmon_dcache_sum  
   called by proc sybsystemprocs..sp_sysmon_dcache  
      called by proc sybsystemprocs..sp_sysmon_analyze  
read by proc sybsystemprocs..sp_shmdumpsize  
   called by proc sybsystemprocs..sp_shmdumpdisp  
read by proc sybsystemprocs..sp_default_charset  
read by proc sybsystemprocs..sp_monitor_list  
read by proc sybsystemprocs..sp_monitor_getcfgnum  
   called by proc sybsystemprocs..sp_monitor_enable  
   called by proc sybsystemprocs..sp_monitor_verify_setup  
      called by proc sybsystemprocs..sp_monitor_deadlock  
         called by proc sybsystemprocs..sp_monitor  
      called by proc sybsystemprocs..sp_monitor_connection  
      called by proc sybsystemprocs..sp_monitor_event  
      called by proc sybsystemprocs..sp_monitor_archive  
         called by proc sybsystemprocs..sp_monitor_deadlock  
      called by proc sybsystemprocs..sp_monitor_procedure  
      called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_statement  
      called by proc sybsystemprocs..sp_monitor_enable  
      called by proc sybsystemprocs..sp_monitor_disable  
read by proc sybsystemprocs..sp_helpconfig  
read_written by proc sybsystemprocs..sp_do_poolconfig  
read by proc sybsystemprocs..sp_sysmon_dcachestats  
   called by proc sybsystemprocs..sp_sysmon_analyze_mda  
      called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_drv_getsortorder  
read by proc sybsystemprocs..sp_helpcache  
read by proc sybsystemprocs..sp_monitor_getcfgval  
   called by proc sybsystemprocs..sp_monitor_verify_cfgval  
      called by proc sybsystemprocs..sp_monitor_deadlock  
      called by proc sybsystemprocs..sp_monitor_statement  
      called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_connection  
      called by proc sybsystemprocs..sp_monitor_procedure  
      called by proc sybsystemprocs..sp_monitor_event  
      called by proc sybsystemprocs..sp_monitor_archive  
   called by proc sybsystemprocs..sp_monitor_enable  
   called by proc sybsystemprocs..sp_monitor_verify_setup