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

1     create table syspartitions(-- 76 Rows, Data: 8 KB, Index: 28 KB
2         name varchar(255) not null,
3         indid smallint not null,
4         id int not null,
5         partitionid int not null,
6         segment smallint not null,
7         status int not null,
8         datoampage uint not null,
9         indoampage uint not null,
10        firstpage uint not null,
11        rootpage uint not null,
12        data_partitionid int not null,
13        crdate datetime not null,
14        cdataptnname varchar(255) null,
15        lobcomp_lvl tinyint null,
16        ptndcompver tinyint null
17    )
18    
19    
20    create unique clustered index csyspartitions on syspartitions(-- 6 KB refcount: 33
21        id, indid, partitionid
22    )
23    create unique index nc2syspartitions on syspartitions(-- 8 KB refcount: 9
24        id, indid, name
25    )
26    create unique index ncsyspartitions on syspartitions(-- 6 KB refcount: 0
27        partitionid, indid
28    )
29    
30    alter table syspartitions lock datarows
31    
32    Grant Select on syspartitions to public
33    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[segment]sybsystemprocs..syssegments[segment]9 Simple Join
[id, indid]sybsystemprocs..sysindexes[id, indid]5 FK
[id]sybsystemprocs..sysobjects[id]2 FK
[partitionid]sybsystemprocs..syscomments[partitionid]1 Simple Join
[indid]sybsystemprocs..sysindexes[indid]1 Simple Join

Estimated Index Usage
syspartitions.csyspartitions unique clustered(id, indid, partitionid)33
syspartitions.nc2syspartitions unique(id, indid, name)9
syspartitions.ncsyspartitions unique(partitionid, indid)0

ALIASES USED for sybsystemprocs..syspartitions
NO_ALIASpssyspartitions
131716

SCHEMA

COLUMN USAGE
namesp_helpartition  sp_helpdefrag  sp_helpindex  sp_helpsegment  sp_objectsegment  sp_placeobject  sp_rename  sp_spaceusage_object_init  sp_tab_suspectptn 
indidsp_chgattribute  sp_helpartition  sp_helpdefrag  sp_helpindex  sp_helplog  sp_helpsegment  sp_objectsegment  sp_placeobject  sp_rename  sp_spaceusage_object_init  sp_tab_suspectptn 
idsp_chgattribute  sp_helpartition  sp_helpdefrag  sp_helpindex  sp_helplog  sp_helpsegment  sp_objectsegment  sp_placeobject  sp_rename  sp_spaceusage_object_init  sp_tab_suspectptn 
partitionidsp_helpartition  sp_helpdefrag  sp_helplog  sp_placeobject  sp_rename  sp_spaceusage_object_init  sp_tab_suspectptn 
segmentsp_dropsegment  sp_helpartition  sp_helpindex  sp_helpsegment  sp_objectsegment  sp_placeobject 
statussp_helpartition  sp_helpindex 
datoampagesp_spaceusage_object_init 
indoampagesp_spaceusage_object_init 
firstpagesp_helplog 
data_partitionidsp_helpartition  sp_spaceusage_object_init 
crdatesp_helpartition  sp_objectsegment 
cdataptnnamesp_helpartition  sp_placeobject 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_helpartition:105
sybsystemprocs..sp_rename:347
sybsystemprocs..sysindexes sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:128
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..sp_rename:186
sybsystemprocs..sysindexes sybsystemprocs..sp_helpartition:339
sybsystemprocs..sysindexes sybsystemprocs..syssegments sybsystemprocs..sp_dropsegment:289
sybsystemprocs..sp_helpsegment:179
sybsystemprocs..sp_helpsegment:204
sybsystemprocs..syssegments sybsystemprocs..sp_helpartition:587
sybsystemprocs..sp_helpartition:574
sybsystemprocs..sp_helpsegment:193
sybsystemprocs..sp_objectsegment:70
sybsystemprocs..sp_helpartition:490
sybsystemprocs..sp_helpindex:376
sybsystemprocs..syscomments sybsystemprocs..sp_helpartition:617

COLUMN WRITES detailed
ColumnWritten From
name  sp_rename.@newname  
segment  syssegments.segment   sp_addsegment.@?  

DATA PROPAGATION detailed
ColumnWritten To
namesp_tab_suspectptn_rset_001.Partition type, Own.Tab.Ind (Obj_ID, Ind_ID)
partitionidsp_helpartition_rset_001.Avg_pages °.Max_pages °.Min_pages °.Ratio(Max/Avg) °.Ratio(Min/Avg) sp_tab_suspectptn_rset_001.Partition type, Own.Tab.Ind (Obj_ID, Ind_ID)

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_objectsegment  
read_written by proc sybsystemprocs..sp_rename  
read_written by proc sybsystemprocs..sp_placeobject  
read by proc sybsystemprocs..sp_helplog  
read by proc sybsystemprocs..sp_helpdefrag  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_helpsegment  
read by proc sybsystemprocs..sp_dropsegment  
read by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_chgattribute  
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_tab_suspectptn