DatabaseTableApplicationCreatedLinks
sybsystemprocssysqueryplans  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sysqueryplans(-- 0 Rows, Data: 2 KB, Index: 6 KB
2         uid int not null,
3         gid int not null,
4         hashkey int not null,
5         id int not null,
6         type smallint not null,
7         sequence smallint not null,
8         status int null,
9         text varchar(255) null,
10        dbid int null,
11        qpdate datetime null,
12        sprocid int null,
13        hashkey2 int null,
14        key1 int null,
15        key2 int null,
16        key3 int null,
17        key4 int null
18    )
19    
20    
21    create unique clustered index csysqueryplans on sysqueryplans(-- 2 KB refcount: 105
22        uid, gid, hashkey, id, type, sequence
23    )
24    create unique index ncsysqueryplans on sysqueryplans(-- 2 KB refcount: 8
25        id, type, sequence
26    )
27    
28    alter table sysqueryplans lock datarows
29    
30    Grant Select on sysqueryplans to public
31    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysqueryplans[id]24 Simple Join
[sequence]sybsystemprocs..sysqueryplans[sequence]4 Simple Join
[text]sybsystemprocs..sysqueryplans[text]2 Simple Join
[type, sequence]sybsystemprocs..sysqueryplans[type, sequence]2 Simple Join
[uid, gid, hashkey]sybsystemprocs..sysqueryplans[uid, gid, hashkey]2 Simple Join
[uid, gid, id]sybsystemprocs..sysqueryplans[uid, gid, id]2 Simple Join
[uid, hashkey, type, sequence, text]sybsystemprocs..sysqueryplans[uid, hashkey, type, sequence, text]2 Simple Join

Estimated Index Usage
sysqueryplans.csysqueryplans unique clustered(uid, gid, hashkey, id, type, sequence)105
sysqueryplans.ncsysqueryplans unique(id, type, sequence)8

ALIASES USED for sybsystemprocs..sysqueryplans
NO_ALIASabg1g2inextop1p2prevqsq1sq2sq3sq4sysqueryplans
4011115152211332211

SCHEMA

COLUMN USAGE
uidsp_cmp_all_qplans  sp_cmp_qplans  sp_copy_all_qplans  sp_copy_qplan  sp_drop_all_qplans  sp_drop_metrics  sp_drop_qplan  sp_drop_query_tuning  sp_find_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sp_set_qplan  sp_show_query_tuning  sysquerymetrics 
gidsp_backup_metrics  sp_cmp_all_qplans  sp_copy_all_qplans  sp_copy_qplan  sp_drop_all_qplans  sp_drop_metrics  sp_drop_qpgroup  sp_drop_query_tuning  sp_filter_metrics  sp_find_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sp_show_query_tuning  sysquerymetrics 
hashkeysp_cmp_all_qplans  sp_cmp_qplans  sp_copy_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sysquerymetrics 
idsp_cmp_all_qplans  sp_cmp_qplans  sp_copy_all_qplans  sp_copy_qplan  sp_drop_all_qplans  sp_drop_metrics  sp_drop_qplan  sp_drop_query_tuning  sp_find_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sp_set_qplan  sp_show_query_tuning  sysquerymetrics 
typesp_cmp_all_qplans  sp_cmp_qplans  sp_copy_all_qplans  sp_copy_qplan  sp_drop_all_qplans  sp_drop_query_tuning  sp_find_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sp_set_qplan  sp_show_query_tuning  sysquerymetrics 
sequencesp_cmp_all_qplans  sp_cmp_qplans  sp_copy_qplan  sp_find_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sp_set_qplan  sp_show_query_tuning  sysquerymetrics 
statussp_copy_qplan  sp_import_qpgroup  sp_show_query_tuning 
textsp_cmp_all_qplans  sp_cmp_qplans  sp_copy_qplan  sp_find_qplan  sp_help_qpgroup  sp_help_qplan  sp_import_qpgroup  sp_set_qplan  sp_show_query_tuning  sysquerymetrics 
dbidsp_copy_qplan  sp_import_qpgroup 
qpdatesp_copy_qplan  sp_import_qpgroup 
sprocidsp_copy_qplan  sp_import_qpgroup 
hashkey2sp_copy_qplan  sp_import_qpgroup 
key1sp_copy_qplan  sp_import_qpgroup 
key2sp_copy_qplan  sp_import_qpgroup 
key3sp_copy_qplan  sp_import_qpgroup 
key4sp_copy_qplan  sp_import_qpgroup 

QUERIES
Joined With Links
sybsystemprocs..sp_show_query_tuning:81
sybsystemprocs..sp_cmp_qplans:178
sybsystemprocs..sp_help_qpgroup:183
sybsystemprocs..sysquerymetrics:1
sybsystemprocs..sp_help_qpgroup:241
sybsystemprocs..sp_help_qpgroup:258
sybsystemprocs..sp_show_query_tuning:97
sybsystemprocs..sp_help_qpgroup:236
sybsystemprocs..sp_cmp_qplans:145
sybsystemprocs..sp_show_query_tuning:108
sybsystemprocs..sp_help_qpgroup:275
sybsystemprocs..sp_show_query_tuning:70
sybsystemprocs..sp_show_query_tuning:75
sybsystemprocs..sp_show_query_tuning:102
sybsystemprocs..sp_cmp_all_qplans:141
sybsystemprocs..sp_help_qpgroup:294
sybsystemprocs..sp_drop_query_tuning:99

COLUMN WRITES detailed
ColumnWritten From
uid  sysqueryplans.uid   sp_import_qpgroup.@?   sp_import_qpgroup.@usr  
gid    sysdatabases.dbid   sysattributes.object   sysobjects.id   sp_config_rep_agent.@?   sp_aux_parse_entity.@?   sp_metrics.@arg1   sp_metrics.@?   sp_logiosize.@?   sp_setlockpromote.@?   sp_unbindcache.@tablename   sp_add_qpgroup.@?   sp_setlockpromote_ptn.@?   sp_unbindcache.@dbname  
hashkey  sysqueryplans.hashkey  
type  sysqueryplans.type  
sequence  sysqueryplans.sequence  
status  sysqueryplans.status  
text  sysqueryplans.text   sp_set_qplan.@plan  
dbid  sysqueryplans.dbid  
qpdate  sysqueryplans.qpdate  
sprocid  sysqueryplans.sprocid  
hashkey2  sysqueryplans.hashkey2  
key1  sysqueryplans.key1  
key2  sysqueryplans.key2  
key3  sysqueryplans.key3  
key4  sysqueryplans.key4  

DATA PROPAGATION detailed
ColumnWritten To
dbidsysqueryplans.dbid  
gidsp_find_qplan_rset_001.gid sp_help_qplan_rset_001.hashkey sp_help_qplan_rset_004.query_plan sp_show_metrics_rset_001.Group ID sp_show_query_tuning_rset_001.Group ID
hashkeysysqueryplans.hashkey   sp_help_qpgroup_rset_002.Rows sp_help_qpgroup_rset_003.Rows sp_help_qpgroup_rset_004.Hashkeys sp_help_qpgroup_rset_005.hashkey sp_help_qpgroup_rset_006.hashkey sp_help_qpgroup_rset_007.hashkey sp_help_qplan_rset_001.id sp_help_qplan_rset_005.gid
hashkey2sysqueryplans.hashkey2  
idsp_cmp_all_qplans_rset_002.id1 sp_cmp_all_qplans_rset_004.id1 °.id2 sp_cmp_all_qplans_rset_006.id sp_cmp_all_qplans_rset_008.id sp_find_qplan_rset_001.id sp_help_qpgroup_rset_002.Plans sp_help_qpgroup_rset_003.Plan sp_help_qpgroup_rset_008.id sp_help_qpgroup_rset_010.Chars
sp_help_qplan_rset_001.query sp_help_qplan_rset_005.hashkey sp_show_query_tuning_rset_002.id sp_show_query_tuning_rset_003.id
key1sysqueryplans.key1  
key2sysqueryplans.key2  
key3sysqueryplans.key3  
key4sysqueryplans.key4  
qpdatesysqueryplans.qpdate  
sequencesysqueryplans.sequence   sp_show_query_tuning_rset_002.sequence sp_show_query_tuning_rset_003.sequence
sprocidsysqueryplans.sprocid  
statussysqueryplans.status  
textsysqueryplans.text   sp_find_qplan_rset_001.text sp_help_qpgroup_rset_001.Total QueryPlans sp_help_qplan_rset_002.gid sp_help_qplan_rset_003.query sp_help_qplan_rset_005.id sp_show_query_tuning_rset_002.text sp_show_query_tuning_rset_003.text
typesysqueryplans.type  
uidsysqueryplans.uid  

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_drop_metrics  
   called by proc sybsystemprocs..sp_metrics  
read_written by proc sybsystemprocs..sp_copy_qplan  
   called by proc sybsystemprocs..sp_copy_all_qplans  
read by proc sybsystemprocs..sp_copy_all_qplans  
read by proc sybsystemprocs..sp_find_qplan  
read by proc sybsystemprocs..sp_show_query_tuning  
   called by proc sybsystemprocs..sp_query_tuning  
read by proc sybsystemprocs..sp_help_qpgroup  
read by proc sybsystemprocs..sp_filter_metrics  
   called by proc sybsystemprocs..sp_metrics  
read_written by proc sybsystemprocs..sp_drop_query_tuning  
   called by proc sybsystemprocs..sp_query_tuning  
written by proc sybsystemprocs..sp_drop_qplan  
read_written by proc sybsystemprocs..sp_drop_all_qplans  
read_written by proc sybsystemprocs..sp_import_qpgroup  
read by proc sybsystemprocs..sp_cmp_all_qplans  
read_written by proc sybsystemprocs..sp_backup_metrics  
   called by proc sybsystemprocs..sp_metrics  
read_written by proc sybsystemprocs..sp_set_qplan  
read by proc sybsystemprocs..sp_cmp_qplans  
   called by proc sybsystemprocs..sp_copy_qplan  
read by proc sybsystemprocs..sp_drop_qpgroup  
read by proc sybsystemprocs..sp_help_qplan  
   called by proc sybsystemprocs..sp_cmp_all_qplans  
read by view sybsystemprocs..sysquerymetrics  
   read by proc sybsystemprocs..sp_show_metrics  
      called by proc sybsystemprocs..sp_metrics