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

1     create table systabstats(-- 6 Rows, Data: 2 KB, Index: 4 KB
2         indid smallint not null,
3         id int not null,
4         activestatid smallint not null,
5         indexheight smallint not null,
6         leafcnt uint not null,
7         pagecnt uint not null,
8         rowcnt float not null,
9         forwrowcnt float not null,
10        delrowcnt float not null,
11        dpagecrcnt float not null,
12        ipagecrcnt float not null,
13        drowcrcnt float not null,
14        oamapgcnt int not null,
15        extent0pgcnt int not null,
16        datarowsize float not null,
17        leafrowsize float not null,
18        status int not null,
19        plljoindegree int not null,
20        rslastoam int not null,
21        rslastpage int not null,
22        frlastoam int not null,
23        frlastpage int not null,
24        conopt_thld smallint not null,
25        plldegree smallint not null,
26        emptypgcnt uint not null,
27        partitionid int not null,
28        warmcachepgcnt uint not null,
29        statmoddate datetime not null,
30        unusedpgcnt uint not null,
31        oampagecnt uint not null,
32        pioclmdata real not null,
33        pioclmindex real not null,
34        piocsmdata real not null,
35        piocsmindex real not null
36    )
37    
38    
39    create unique clustered index csystabstats on systabstats(-- 2 KB refcount: 7
40        id, indid, partitionid
41    )
42    
43    alter table systabstats lock datarows
44    
45    Grant Select on systabstats to public
46    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength

Estimated Index Usage
systabstats.csystabstats unique clustered(id, indid, partitionid)7

ALIASES USED for sybsystemprocs..systabstats
NO_ALIASsystabstatstts
4211

SCHEMA

COLUMN USAGE
indidsp_chgattribute  sp_help  sp_spaceusage_object_init 
idsp_chgattribute  sp_help  sp_spaceusage_object_init  sp_spaceused 
indexheightsp_spaceusage_object_init 
leafcntsp_spaceusage_object_init 
rowcntsp_spaceusage_object_init 
forwrowcntsp_spaceusage_object_init 
delrowcntsp_spaceusage_object_init 
oamapgcntsp_spaceusage_object_init 
extent0pgcntsp_spaceusage_object_init 
datarowsizesp_spaceusage_object_init 
leafrowsizesp_spaceusage_object_init 
statussp_spaceusage_object_init 
conopt_thldsp_chgattribute  sp_help 
plldegreesp_chgattribute 
emptypgcntsp_spaceusage_object_init  sp_spaceused 
partitionidsp_spaceusage_object_init 
statmoddatesp_spaceusage_object_init 

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
conopt_thld  sp_chgattribute.@optvalue   sp_chgattribute.@?  
plldegree  sp_chgattribute.@optvalue   sp_chgattribute.@?  

DATA PROPAGATION detailed
ColumnWritten To
conopt_thldsp_help_rset_001.exp_row_size

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_spaceusage_object_init  
   called by proc sybsystemprocs..sp_spaceusage_object  
      called by proc sybsystemprocs..sp_spaceusage  
read_written by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_spaceused  
read by proc sybsystemprocs..sp_help