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

1     create table sysindexes(-- 6 Rows, Data: 14 KB, Index: 20 KB
2         name longsysname(255) null,
3         id int not null,
4         indid smallint not null,
5         doampg int not null,
6         ioampg int not null,
7         oampgtrips int not null,
8         status3 smallint not null,
9         status2 smallint not null,
10        ipgtrips int not null,
11        first int not null,
12        root int not null,
13        distribution int not null,
14        usagecnt smallint not null,
15        segment smallint not null,
16        status smallint not null,
17        maxrowsperpage smallint not null,
18        minlen smallint not null,
19        maxlen smallint not null,
20        maxirow smallint not null,
21        keycnt smallint not null,
22        keys1 varbinary(255) null,
23        keys2 varbinary(255) null,
24        soid tinyint not null,
25        csid tinyint not null,
26        base_partition int null,
27        fill_factor smallint null,
28        res_page_gap smallint null,
29        exp_rowsize smallint null,
30        keys3 varbinary(255) null,
31        identitygap int null,
32        crdate datetime null,
33        partitiontype smallint null,
34        conditionid int null
35    )
36    
37    
38    create unique clustered index csysindexes on sysindexes(-- 6 KB refcount: 196
39        id, indid
40    )
41    
42    alter table sysindexes lock datarows
43    
44    Grant Select on sysindexes to public
45    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]29 FK
[id]sybsystemprocs..syscolumns[id]13 Simple Join
[partitiontype]master..spt_values[number]5 Simple Join
[id, indid]sybsystemprocs..syspartitions[id, indid]5 Rev FK
[name]master..spt_values[name]3 Simple Join
[segment]sybsystemprocs..syssegments[segment]3 Simple Join
[id, indid]sybsystemprocs..syspartitionkeys[id, indid]2 Rev FK
[id]sybsystemprocs..sysattributes[object]1 Simple Join
[name]sybsystemprocs..sysobjects[name]1 Simple Join
[indid]sybsystemprocs..syspartitionkeys[indid]1 Simple Join
[indid]sybsystemprocs..syspartitions[indid]1 Simple Join

Estimated Index Usage
sysindexes.csysindexes unique clustered(id, indid)196

ALIASES USED for sybsystemprocs..sysindexes
NO_ALIASii1i2ssisysindexesx
655023321614

SCHEMA

COLUMN USAGE
namesp_aux_parse_entity  sp_cachestrategy  sp_checknames  sp_checkreswords  sp_chgattribute  sp_dcachestats_obj_details  sp_depends_cols  sp_dwngd_helpindex  sp_estspace  sp_fixindex  sp_help  sp_helpartition  sp_helpconstraint  sp_helpindex  sp_helpsegment  sp_ijdbc_fkeys  sp_ijdbc_getindexinfo  sp_ijdbc_primarykey  sp_index_row_size_est  sp_index_space_est  sp_indsuspect  sp_jdbc_fkeys  sp_jdbc_getindexinfo  sp_jdbc_primarykey  sp_lookup  sp_odbc_fkeys  sp_odbc_getindexinfo  sp_odbc_primarykey  sp_oledb_fkeys  sp_oledb_primarykey  sp_oledb_statistics  sp_placeobject  sp_rename  sp_setreptable  sp_spaceusage_object_init  sp_spaceused  sp_statistics  sp_tab_suspectptn 
idsp_aux_parse_entity  sp_cachestrategy  sp_checknames  sp_checkreswords  sp_chgattribute  sp_dcachestats_obj_details  sp_depends_cols  sp_drv_bcpmetadata  sp_dwngd_helpindex  sp_estspace  sp_fixindex  sp_help  sp_helpartition  sp_helpconfig_process_estimate  sp_helpconstraint  sp_helpindex  sp_helpsegment  sp_ijdbc_fkeys  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getindexinfo  sp_ijdbc_primarykey  sp_index_row_size_est  sp_index_space_est  sp_indsuspect  sp_jdbc_fkeys  sp_jdbc_getbestrowidentifier  sp_jdbc_getindexinfo  sp_jdbc_primarykey  sp_lookup  sp_odbc_fkeys  sp_odbc_getindexinfo  sp_odbc_getversioncolumns  sp_odbc_primarykey  sp_oledb_fkeys  sp_oledb_primarykey  sp_oledb_statistics  sp_optimal_text_space  sp_pkeys  sp_placeobject  sp_post_xpload  sp_rename  sp_setreptable  sp_spaceusage_object_init  sp_spaceused  sp_special_columns  sp_statistics  sp_tab_suspectptn 
indidsp_aux_parse_entity  sp_cachestrategy  sp_checknames  sp_checkreswords  sp_chgattribute  sp_dcachestats_obj_details  sp_depends_cols  sp_drv_bcpmetadata  sp_estspace  sp_fixindex  sp_help  sp_helpartition  sp_helpconfig_process_estimate  sp_helpconstraint  sp_helpindex  sp_helpsegment  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getindexinfo  sp_ijdbc_primarykey  sp_index_row_size_est  sp_index_space_est  sp_indsuspect  sp_jdbc_getbestrowidentifier  sp_jdbc_getindexinfo  sp_jdbc_primarykey  sp_lookup  sp_odbc_getindexinfo  sp_odbc_getversioncolumns  sp_odbc_primarykey  sp_oledb_primarykey  sp_optimal_text_space  sp_pkeys  sp_placeobject  sp_post_xpload  sp_rename  sp_setreptable  sp_spaceusage_object_init  sp_spaceused  sp_special_columns  sp_statistics  sp_tab_suspectptn 
status3sp_chgattribute  sp_helpartition  sp_helpconfig_process_estimate  sp_helpindex  sp_post_xpload  sp_tab_suspectptn 
status2sp_cachestrategy  sp_depends_cols  sp_estspace  sp_help  sp_helpconstraint  sp_helpindex  sp_ijdbc_primarykey  sp_index_space_est  sp_jdbc_primarykey  sp_odbc_getindexinfo  sp_odbc_primarykey  sp_oledb_primarykey  sp_pkeys  sp_placeobject  sp_rename  sp_statistics 
segmentsp_dropsegment  sp_helpsegment  sp_placeobject 
statussp_dwngd_helpindex  sp_helpconstraint  sp_helpindex  sp_ijdbc_fkeys  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getindexinfo  sp_ijdbc_primarykey  sp_indsuspect  sp_jdbc_fkeys  sp_jdbc_getbestrowidentifier  sp_jdbc_getindexinfo  sp_jdbc_primarykey  sp_odbc_fkeys  sp_odbc_getindexinfo  sp_odbc_getversioncolumns  sp_odbc_primarykey  sp_oledb_fkeys  sp_oledb_primarykey  sp_pkeys  sp_special_columns  sp_statistics 
maxrowsperpagesp_chgattribute  sp_estspace  sp_help  sp_helpindex  sp_spaceusage_object_init 
maxlensp_drv_bcpmetadata 
keycntsp_depends_cols  sp_help  sp_helpconfig_process_estimate  sp_helpconstraint  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getindexinfo  sp_ijdbc_primarykey  sp_jdbc_getbestrowidentifier  sp_jdbc_getindexinfo  sp_jdbc_primarykey  sp_odbc_getindexinfo  sp_odbc_getversioncolumns  sp_odbc_primarykey  sp_pkeys  sp_special_columns  sp_statistics 
fill_factorsp_chgattribute  sp_help  sp_helpindex  sp_spaceusage_object_init 
res_page_gapsp_chgattribute  sp_help  sp_helpindex  sp_spaceusage_object_init 
exp_rowsizesp_chgattribute  sp_help  sp_spaceusage_object_init 
identitygapsp_chgattribute  sp_help 
crdatesp_helpconstraint  sp_helpindex 
partitiontypesp_helpartition  sp_post_xpload  sp_tab_suspectptn 
conditionidsp_helpartition 

QUERIES
Joined With Links
sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_checkreswords:208
sybsystemprocs..sp_checkreswords:152
sybsystemprocs..sp_checkreswords:111
sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:69
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_odbc_getindexinfo:115
sybsystemprocs..sp_statistics:116
sybsystemprocs..sp_oledb_primarykey:70
sybsystemprocs..sp_jdbc_getindexinfo:139
sybsystemprocs..sysobjects sybsystemprocs..sp_odbc_getindexinfo:180
sybsystemprocs..sp_ijdbc_primarykey:101
sybsystemprocs..sp_post_xpload:135
sybsystemprocs..sp_oledb_statistics:183
sybsystemprocs..sp_jdbc_getindexinfo:197
sybsystemprocs..sp_chgattribute:163
sybsystemprocs..sp_helpartition:104
sybsystemprocs..sp_lookup:59
sybsystemprocs..sp_rename:329
sybsystemprocs..sp_post_xpload:123
sybsystemprocs..sp_chgattribute:151
sybsystemprocs..sp_statistics:191
sybsystemprocs..sp_dwngd_helpindex:37
master..spt_values sybsystemprocs..sp_helpartition:109
sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_indsuspect:115
sybsystemprocs..sp_indsuspect:56
sybsystemprocs..sysobjects sybsystemprocs..syspartitions master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:128
sybsystemprocs..sysobjects sybsystemprocs..syspartitions sybsystemprocs..sp_rename:186
sybsystemprocs..syscolumns sybsystemprocs..syspartitionkeys sybsystemprocs..sp_post_xpload:174
sybsystemprocs..sp_post_xpload:191
sybsystemprocs..syssegments sybsystemprocs..sp_helpsegment:217
sybsystemprocs..sp_helpsegment:228
sybsystemprocs..sysattributes master..sysattributes master..sysattributes sybsystemprocs..sp_spaceused:449
sybsystemprocs..syspartitions sybsystemprocs..sp_helpartition:339
sybsystemprocs..syspartitions sybsystemprocs..syssegments sybsystemprocs..sp_dropsegment:289
sybsystemprocs..sp_helpsegment:179
sybsystemprocs..sp_helpsegment:204
sybsystemprocs..syspartitionkeys sybsystemprocs..sp_helpartition:320

COLUMN WRITES detailed
ColumnWritten From
name  sp_rename.@?   sp_rename.@newname  
status3  sysindexes.status3   sp_chgattribute.@?  
status2  sysindexes.status2   sp_rename.@?   sp_cachestrategy.@?  
segment  syssegments.segment   sp_addsegment.@?  
maxrowsperpage  sp_chgattribute.@optvalue   sp_chgattribute.@?  
fill_factor  sp_chgattribute.@optvalue   sp_chgattribute.@?  
res_page_gap  sp_chgattribute.@optvalue   sp_chgattribute.@?  
exp_rowsize  sp_chgattribute.@?  
identitygap  sp_chgattribute.@optvalue  

DATA PROPAGATION detailed
ColumnWritten To
crdatesp_helpconstraint_rset_002.created sp_helpconstraint_rset_003.created sp_helpconstraint_rset_004.created
exp_rowsizesp_help_rset_002.concurrency_opt_threshold
fill_factorsp_help_rset_002.dealloc_first_txtpg
idsp_checknames_rset_004.suid sp_jdbc_getindexinfo_rset_001.CARDINALITY °.PAGES sp_jdbc_getindexinfo_rset_002.CARDINALITY °.PAGES sp_odbc_getindexinfo_rset_001.CARDINALITY °.PAGES sp_odbc_getindexinfo_rset_002.CARDINALITY °.PAGES sp_oledb_statistics_rset_001.CARDINALITY
sp_statistics_rset_001.cardinality °.pages sp_statistics_rset_002.cardinality °.pages
indidsysattributes.object_info1   °.char_value   sysattributes.object_info1   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_004.name sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name
sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Object °.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_helpartition_rset_001.Avg_pages °.Max_pages
°.Min_pages °.Ratio(Max/Avg) °.Ratio(Min/Avg) sp_indsuspect_rset_001.Own.Tab.Ind (Obj_ID, Ind_ID) sp_indsuspect_rset_002.Own.Tab.Ind (Obj_ID, Ind_ID) sp_jdbc_getbestrowidentifier_rset_001.COLUMN_NAME sp_jdbc_getindexinfo_rset_001.COLUMN_NAME °.PAGES sp_jdbc_getindexinfo_rset_002.COLUMN_NAME °.PAGES
sp_jdbc_primarykey_rset_001.COLUMN_NAME sp_listsuspect_object_rset_001.Object °.Access sp_listsuspect_page_rset_001.Object °.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType °.ErrType
°.Delay °.TotalNum sp_makesuspect_obj_rset_002.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Obj
°.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_odbc_getindexinfo_rset_001.COLUMN_NAME °.ASC_OR_DESC °.PAGES
sp_odbc_getindexinfo_rset_002.COLUMN_NAME °.ASC_OR_DESC °.PAGES sp_odbc_getversioncolumns_rset_001.COLUMN_NAME sp_odbc_primarykey_rset_001.COLUMN_NAME sp_oledb_primarykey_rset_001.COLUMN_NAME sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option
sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_special_columns_rset_001.column_name sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference sp_statistics_rset_001.column_name °.collation °.pages sp_statistics_rset_002.column_name
°.collation °.pages sp_tab_suspectptn_rset_001.Partition type, Own.Tab.Ind (Obj_ID, Ind_ID) sp_tab_suspectptn_rset_002.Partition Type, Own.Tab.Ind.Ptn (Obj_ID, Ind_ID, Ptn_ID)
maxrowsperpagesp_estspace_rset_001.Total_Mbytes sp_estspace_rset_002.Total_Mbytes sp_help_rset_002.cached_index_root_page
namesp_cachestrategy_rset_001.index name sp_checknames_rset_004.dbname sp_helpconstraint_rset_002.name sp_helpconstraint_rset_003.name sp_helpconstraint_rset_004.name sp_indsuspect_rset_001.Own.Tab.Ind (Obj_ID, Ind_ID) sp_indsuspect_rset_002.Own.Tab.Ind (Obj_ID, Ind_ID) sp_jdbc_fkeys_rset_001.PK_NAME sp_jdbc_fkeys_rset_002.PK_NAME sp_jdbc_fkeys_rset_003.PK_NAME
sp_jdbc_getindexinfo_rset_001.INDEX_NAME sp_jdbc_getindexinfo_rset_002.INDEX_NAME sp_jdbc_primarykey_rset_001.PK_NAME sp_odbc_fkeys_rset_001.PK_NAME sp_odbc_fkeys_rset_002.PK_NAME sp_odbc_getindexinfo_rset_001.INDEX_NAME sp_odbc_getindexinfo_rset_002.INDEX_NAME sp_odbc_primarykey_rset_001.PK_NAME sp_oledb_fkeys_rset_001.PK_NAME sp_oledb_primarykey_rset_001.PK_NAME
sp_statistics_rset_001.index_name sp_statistics_rset_002.index_name sp_tab_suspectptn_rset_001.Partition type, Own.Tab.Ind (Obj_ID, Ind_ID) sp_tab_suspectptn_rset_002.Partition Type, Own.Tab.Ind.Ptn (Obj_ID, Ind_ID, Ptn_ID)
res_page_gapsp_help_rset_002.optimistic_index_lock
status2sysindexes.status2  
status3sysindexes.status3  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_drv_bcpmetadata  
read by proc sybsystemprocs..sp_indsuspect  
read by proc sybsystemprocs..sp_fixindex  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_optimal_text_space  
   called by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_lookup  
read by proc sybsystemprocs..sp_odbc_getversioncolumns  
read_written by proc sybsystemprocs..sp_rename  
read by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier  
read by proc sybsystemprocs..sp_odbc_fkeys  
read by proc sybsystemprocs..sp_special_columns  
read_written by proc sybsystemprocs..sp_placeobject  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_ijdbc_fkeys  
   called by proc sybsystemprocs..sp_ijdbc_importkey  
   called by proc sybsystemprocs..sp_ijdbc_getcrossreferences  
   called by proc sybsystemprocs..sp_ijdbc_exportkey  
read by proc sybsystemprocs..sp_oledb_fkeys  
read by proc sybsystemprocs..sp_jdbc_fkeys  
   called by proc sybsystemprocs..sp_jdbc_exportkey  
   called by proc sybsystemprocs..sp_jdbc_importkey  
   called by proc sybsystemprocs..sp_jdbc_getcrossreferences  
read by proc sybsystemprocs..sp_oledb_statistics  
read by proc sybsystemprocs..sp_jdbc_getbestrowidentifier  
read by proc sybsystemprocs..sp_tab_suspectptn  
read by proc sybsystemprocs..sp_odbc_getindexinfo  
read by proc sybsystemprocs..sp_depends_cols  
   called by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_dcachestats_obj_details  
read by proc sybsystemprocs..sp_oledb_primarykey  
read by proc sybsystemprocs..sp_helpconstraint  
read by proc sybsystemprocs..sp_index_row_size_est  
   called by proc sybsystemprocs..sp_spaceusage_object_populate  
      called by proc sybsystemprocs..sp_spaceusage_object  
         called by proc sybsystemprocs..sp_spaceusage  
read_written by proc sybsystemprocs..sp_cachestrategy  
read by proc sybsystemprocs..sp_pkeys  
read by proc sybsystemprocs..sp_statistics  
read by proc sybsystemprocs..sp_jdbc_getindexinfo  
read by proc sybsystemprocs..sp_index_space_est  
   called by proc sybsystemprocs..sp_spaceusage_object_populate  
read by proc sybsystemprocs..sp_helpconfig_process_estimate  
   called by proc sybsystemprocs..sp_helpconfig_est_compinfo_poolsize  
read by proc sybsystemprocs..sp_ijdbc_primarykey  
read by proc sybsystemprocs..sp_dropsegment  
read by proc sybsystemprocs..sp_estspace  
read by proc sybsystemprocs..sp_dwngd_helpindex  
read by proc sybsystemprocs..sp_post_xpload  
read by proc sybsystemprocs..sp_helpsegment  
read by proc sybsystemprocs..sp_odbc_primarykey  
read by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_spaceusage_object_init  
   called by proc sybsystemprocs..sp_spaceusage_object  
read by proc sybsystemprocs..sp_spaceused  
read_written by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_jdbc_primarykey  
read by proc sybsystemprocs..sp_setreptable  
read by proc sybsystemprocs..sp_ijdbc_getindexinfo  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_aux_parse_entity  
   called by proc sybsystemprocs..sp_cachestrategy  
   called by proc sybsystemprocs..sp_bindcache  
      called by proc sybsystemprocs..sp_unbindcache