DatabaseTableApplicationCreatedLinks
sybsystemprocssysindexes  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysindexes(-- 6 Rows, Data: 16 KB, Index: 22 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    create unique clustered index csysindexes on sysindexes(-- 6 KB refcount: 177
38        id, indid
39    )
40    
41    alter table sysindexes lock datarows
42    
43    Grant Select on sysindexes to public
44    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]56 FK
[id]sybsystemprocs..syscolumns[id]26 Simple Join
[partitiontype]master..spt_values[number]10 Simple Join
[name]master..spt_values[name]6 Simple Join
[segment]sybsystemprocs..syssegments[segment]6 Simple Join
[id, indid]sybsystemprocs..syspartitions[id, indid]6 Rev FK
[id, indid]sybsystemprocs..syspartitionkeys[id, indid]4 Rev FK
[id]sybsystemprocs..sysattributes[object]2 Simple Join
[name]sybsystemprocs..sysobjects[name]2 Simple Join
[indid]sybsystemprocs..syspartitionkeys[indid]2 Simple Join
[indid]sybsystemprocs..syspartitions[indid]2 Simple Join

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

ALIASES USED for sybsystemprocs..sysindexes
NO_ALIASii1i2ssisysindexesx
663923421614

SCHEMA

COLUMN USAGE
namesp_aux_parse_entity  sp_cachestrategy  sp_checknames  sp_checkreswords  sp_chgattribute  sp_dcachestats_obj_details  sp_depends_cols  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_estspace  sp_fixindex  sp_help  sp_helpartition  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_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_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_statistics 
segmentsp_dropsegment  sp_helpsegment  sp_placeobject 
statussp_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_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:108
sybsystemprocs..sp_checkreswords:205
sybsystemprocs..sp_checkreswords:149
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_jdbc_getindexinfo:141
sybsystemprocs..sp_oledb_primarykey:67
sybsystemprocs..sp_statistics:116
sybsystemprocs..sp_odbc_getindexinfo:113
sybsystemprocs..sysobjects sybsystemprocs..sp_helpartition:104
sybsystemprocs..sp_post_xpload:77
sybsystemprocs..sp_chgattribute:147
sybsystemprocs..sp_post_xpload:89
sybsystemprocs..sp_chgattribute:159
sybsystemprocs..sp_oledb_statistics:183
sybsystemprocs..sp_lookup:59
sybsystemprocs..sp_spaceused:436
sybsystemprocs..sp_ijdbc_primarykey:101
sybsystemprocs..sp_rename:209
sybsystemprocs..sp_odbc_getindexinfo:178
sybsystemprocs..sp_statistics:191
sybsystemprocs..sp_jdbc_getindexinfo:199
sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:69
master..spt_values sybsystemprocs..sp_helpartition:109
sybsystemprocs..sysobjects sybsystemprocs..syspartitions master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:128
sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_indsuspect:56
sybsystemprocs..sp_indsuspect:115
sybsystemprocs..syscolumns sybsystemprocs..syspartitionkeys sybsystemprocs..sp_post_xpload:128
sybsystemprocs..sp_post_xpload:145
sybsystemprocs..syssegments sybsystemprocs..sp_helpsegment:215
sybsystemprocs..sp_helpsegment:205
master..sysattributes sybsystemprocs..sysattributes master..sysattributes sybsystemprocs..sp_spaceused:267
sybsystemprocs..syspartitions sybsystemprocs..sp_helpartition:339
sybsystemprocs..syspartitions sybsystemprocs..syssegments sybsystemprocs..sp_dropsegment:259
sybsystemprocs..sp_helpsegment:193
sybsystemprocs..syspartitionkeys sybsystemprocs..sp_helpartition:320

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