Database reference - HR

HR -  indexes -  HR.RSK_VERTRAGSAGGREGAT_T.RSK_VERTRAGSAGGREGAT_UI

Index properties

namevalue
nameHR.RSK_VERTRAGSAGGREGAT_T.RSK_VERTRAGSAGGREGAT_UI 
size0 kb
typeNORMAL 
parentRSK_VERTRAGSAGGREGAT_T 
uniquenessUNIQUE 
compressionDISABLED 
blevel
leaf blocks
distinct keys
avg leaf blocks per key
avg data blocks per key
clustering factor
statusVALID 
num rows
sample size
last analyzed11/18/2010 10:00:04 PM 
degree
instances
partitionedNO 
temporary
generated
secondary
user statsNO 
global statsYES 
join indexNO 
iot redundant pkey elimNO 
droppedNO 

Index columns

namepositioncolumn length (bytes)column length (chars)order
VERTRAG_ID  30  30  ASC 
COMMODITY  16  16  ASC 
ZEITRASTER  20  20  ASC 
ZEITSTEMPEL_VON_MET  ASC 
ZEITSTEMPEL_BIS_MET  ASC 
REALISIERT  ASC 
PROFIL_COD  ASC 
VALID_TO  ASC 

Dependency graph

RSK_VERTRAGSAGGREGAT_TRSK_VERTRAGSAGGREGAT_UI

Objects that HR.RSK_VERTRAGSAGGREGAT_T.RSK_VERTRAGSAGGREGAT_UI depends on

nameobject typelevel



Documentation generated by SqlSpec