DVC.DEVICE_PK |
TableName | DVC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DVC.DEVICE_PK Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
DVC.DEVICE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
DVC.DEVICE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DEVICE_PK Bound Attachments |
Name | Current Value |
DVC.DVC_PARENT_RF |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX DVC_PARENT_RF ON DVC(PARENT_DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
DVC.DVC_PARENT_RF Index Columns |
ColumnName | Sort Order |
PARENT_DVC_ID | Ascending |
DVC.DVC_PARENT_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
DVC.DVC_PARENT_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_PARENT_RF Bound Attachments |
Name | Current Value |
DVC.DVC_PARENT_RF |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX DVC_PARENT_RF ON DVC(PARENT_DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
DVC.DVC_PARENT_RF Index Columns |
ColumnName | Sort Order |
PARENT_DVC_ID | Ascending |
DVC.DVC_PARENT_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
DVC.DVC_PARENT_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_PARENT_RF Bound Attachments |
Name | Current Value |
EPICS_DVC_GRP_ITEM.EPICS_DVC_GRP_ITEM_PK |
TableName | EPICS_DVC_GRP_ITEM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EPICS_DVC_GRP_ITEM.EPICS_DVC_GRP_ITEM_PK Index Columns |
ColumnName | Sort Order |
EPICS_DVC_GRP_ID | Ascending |
EPICS_DVC_GRP_ITEM.EPICS_DVC_GRP_ITEM_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
EPICS_DVC_GRP_ITEM.EPICS_DVC_GRP_ITEM_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EPICS_DVC_GRP_ITEM.EPICS_DVC_GRP_ITEM_PK Bound Attachments |
Name | Current Value |
EPICS_DVC_GRP_ITEM.DVC_EPICS_DVC_GRP_ITEM_RF |
TableName | EPICS_DVC_GRP_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX DVC_EPICS_DVC_GRP_ITEM_RF ON EPICS_DVC_GRP_ITEM(DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
EPICS_DVC_GRP_ITEM.DVC_EPICS_DVC_GRP_ITEM_RF Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
EPICS_DVC_GRP_ITEM.DVC_EPICS_DVC_GRP_ITEM_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
EPICS_DVC_GRP_ITEM.DVC_EPICS_DVC_GRP_ITEM_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EPICS_DVC_GRP_ITEM.DVC_EPICS_DVC_GRP_ITEM_RF Bound Attachments |
Name | Current Value |
MACHINE_MODE.MACHINE_MODE_PK |
TableName | MACHINE_MODE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACHINE_MODE.MACHINE_MODE_PK Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
APPR_DTE | Ascending |
CHANNEL_NBR | Ascending |
MACHINE_MODE.MACHINE_MODE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACHINE_MODE.MACHINE_MODE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACHINE_MODE.MACHINE_MODE_PK Bound Attachments |
Name | Current Value |
MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF |
TableName | MACHINE_MODE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MPS_SGNL_PARAM_MACH_MODE_RF ON MACHINE_MODE(DVC_ID, APPR_DTE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
APPR_DTE | Ascending |
MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Bound Attachments |
Name | Current Value |
MACHINE_MODE.MPS_DVC_ID_DVC_FK |
TableName | MACHINE_MODE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MPS_DVC_ID_DVC_FK ON MACHINE_MODE(MPS_DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MACHINE_MODE.MPS_DVC_ID_DVC_FK Index Columns |
ColumnName | Sort Order |
MPS_DVC_ID | Ascending |
MACHINE_MODE.MPS_DVC_ID_DVC_FK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACHINE_MODE.MPS_DVC_ID_DVC_FK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACHINE_MODE.MPS_DVC_ID_DVC_FK Bound Attachments |
Name | Current Value |
MACHINE_MODE_DEF_MASK.MACHINE_MODE_PK_1 |
TableName | MACHINE_MODE_DEF_MASK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACHINE_MODE_DEF_MASK.MACHINE_MODE_PK_1 Index Columns |
ColumnName | Sort Order |
DVC_TYPE_ID | Ascending |
MACHINE_MODE_DEF_MASK.MACHINE_MODE_PK_1 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACHINE_MODE_DEF_MASK.MACHINE_MODE_PK_1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACHINE_MODE_DEF_MASK.MACHINE_MODE_PK_1 Bound Attachments |
Name | Current Value |
MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG |
TableName | MPS_AUDIT_ERR_MSG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Index Columns |
ColumnName | Sort Order |
ERR_NBR | Ascending |
MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Bound Attachments |
Name | Current Value |
MPS_BLM_PARAM.PK_MPS_BLM_PARAM |
TableName | MPS_BLM_PARAM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_BLM_PARAM.PK_MPS_BLM_PARAM Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
APPR_DTE | Ascending |
CHANNEL_NBR | Ascending |
MPS_BLM_PARAM.PK_MPS_BLM_PARAM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_BLM_PARAM.PK_MPS_BLM_PARAM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_BLM_PARAM.PK_MPS_BLM_PARAM Bound Attachments |
Name | Current Value |
MPS_CHAIN.MPS_CHAIN_PK |
TableName | MPS_CHAIN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_CHAIN.MPS_CHAIN_PK Index Columns |
ColumnName | Sort Order |
MPS_CHAIN_ID | Ascending |
MPS_CHAIN.MPS_CHAIN_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_CHAIN.MPS_CHAIN_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_CHAIN.MPS_CHAIN_PK Bound Attachments |
Name | Current Value |
MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT |
TableName | MPS_CHAN_AUDIT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
APPR_DTE | Ascending |
CHANNEL_NBR | Ascending |
AUDIT_DTE | Ascending |
MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Bound Attachments |
Name | Current Value |
MPS_CHAN_AUDIT.FK_MACHINE_MODE |
TableName | MPS_CHAN_AUDIT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX FK_MACHINE_MODE ON MPS_CHAN_AUDIT(DVC_ID, APPR_DTE, CHANNEL_NBR)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MPS_CHAN_AUDIT.FK_MACHINE_MODE Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
APPR_DTE | Ascending |
CHANNEL_NBR | Ascending |
MPS_CHAN_AUDIT.FK_MACHINE_MODE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_CHAN_AUDIT.FK_MACHINE_MODE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_CHAN_AUDIT.FK_MACHINE_MODE Bound Attachments |
Name | Current Value |
MPS_CHAN_AUDIT.FK_ERR_MSG |
TableName | MPS_CHAN_AUDIT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX FK_ERR_MSG ON MPS_CHAN_AUDIT(ERR_NBR)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MPS_CHAN_AUDIT.FK_ERR_MSG Index Columns |
ColumnName | Sort Order |
ERR_NBR | Ascending |
MPS_CHAN_AUDIT.FK_ERR_MSG Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_CHAN_AUDIT.FK_ERR_MSG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_CHAN_AUDIT.FK_ERR_MSG Bound Attachments |
Name | Current Value |
MPS_CHASSIS_SER_NBR.PK318 |
TableName | MPS_CHASSIS_SER_NBR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_CHASSIS_SER_NBR.PK318 Index Columns |
ColumnName | Sort Order |
SER_NBR | Ascending |
MPS_CHASSIS_SER_NBR.PK318 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_CHASSIS_SER_NBR.PK318 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_CHASSIS_SER_NBR.PK318 Bound Attachments |
Name | Current Value |
MPS_DAILY_STAT.PK370 |
TableName | MPS_DAILY_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_DAILY_STAT.PK370 Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
MPS_INP_SGNL_ID | Ascending |
CUR_DTE | Ascending |
MPS_DAILY_STAT.PK370 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_DAILY_STAT.PK370 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_DAILY_STAT.PK370 Bound Attachments |
Name | Current Value |
MPS_DAILY_STAT.Ref102651 |
TableName | MPS_DAILY_STAT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX Ref102651 ON MPS_DAILY_STAT(SGNL_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MPS_DAILY_STAT.Ref102651 Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
MPS_DAILY_STAT.Ref102651 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_DAILY_STAT.Ref102651 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_DAILY_STAT.Ref102651 Bound Attachments |
Name | Current Value |
MPS_DAILY_STAT.Ref102653 |
TableName | MPS_DAILY_STAT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX Ref102653 ON MPS_DAILY_STAT(MPS_INP_SGNL_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MPS_DAILY_STAT.Ref102653 Index Columns |
ColumnName | Sort Order |
MPS_INP_SGNL_ID | Ascending |
MPS_DAILY_STAT.Ref102653 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_DAILY_STAT.Ref102653 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_DAILY_STAT.Ref102653 Bound Attachments |
Name | Current Value |
MPS_PROP.PK317 |
TableName | MPS_PROP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_PROP.PK317 Index Columns |
ColumnName | Sort Order |
EPICS_VER | Ascending |
MPS_PROP.PK317 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_PROP.PK317 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_PROP.PK317 Bound Attachments |
Name | Current Value |
MPS_SGNL_PARAM.MPD_SGNL_PARAM_PK |
TableName | MPS_SGNL_PARAM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MPS_SGNL_PARAM.MPD_SGNL_PARAM_PK Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
APPR_DTE | Ascending |
MPS_SGNL_PARAM.MPD_SGNL_PARAM_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_SGNL_PARAM.MPD_SGNL_PARAM_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_SGNL_PARAM.MPD_SGNL_PARAM_PK Bound Attachments |
Name | Current Value |
MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF |
TableName | MPS_SGNL_PARAM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MPS_SGNL_PARAM_DVC_RF ON MPS_SGNL_PARAM(DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Bound Attachments |
Name | Current Value |
MPS_SGNL_PARAM.MPS_CHAIN_SGNL_PARAM_RF |
TableName | MPS_SGNL_PARAM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MPS_CHAIN_SGNL_PARAM_RF ON MPS_SGNL_PARAM(MPS_CHAIN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
MPS_SGNL_PARAM.MPS_CHAIN_SGNL_PARAM_RF Index Columns |
ColumnName | Sort Order |
MPS_CHAIN_ID | Ascending |
MPS_SGNL_PARAM.MPS_CHAIN_SGNL_PARAM_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MPS_SGNL_PARAM.MPS_CHAIN_SGNL_PARAM_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MPS_SGNL_PARAM.MPS_CHAIN_SGNL_PARAM_RF Bound Attachments |
Name | Current Value |
SGNL.SGNL_PK |
TableName | SGNL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SGNL.SGNL_PK Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
DVC_ID | Ascending |
SGNL.SGNL_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL.SGNL_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL.SGNL_PK Bound Attachments |
Name | Current Value |
SGNL.SGNL_DVC_RF |
TableName | SGNL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SGNL_DVC_RF ON SGNL(DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
SGNL.SGNL_DVC_RF Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
SGNL.SGNL_DVC_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL.SGNL_DVC_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL.SGNL_DVC_RF Bound Attachments |
Name | Current Value |
SGNL.SGNL_REC_SGNL_RF |
TableName | SGNL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SGNL_REC_SGNL_RF ON SGNL(SGNL_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
SGNL.SGNL_REC_SGNL_RF Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
SGNL.SGNL_REC_SGNL_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL.SGNL_REC_SGNL_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL.SGNL_REC_SGNL_RF Bound Attachments |
Name | Current Value |
SGNL_REC.SGNL_REC_PK |
TableName | SGNL_REC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SGNL_REC.SGNL_REC_PK Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
SGNL_REC.SGNL_REC_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL_REC.SGNL_REC_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.SGNL_REC_PK Bound Attachments |
Name | Current Value |
SGNL_REC.DVC_SGNL_REC_RF |
TableName | SGNL_REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX DVC_SGNL_REC_RF ON SGNL_REC(DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE OPER_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 50              ) ; |
SGNL_REC.DVC_SGNL_REC_RF Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
SGNL_REC.DVC_SGNL_REC_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL_REC.DVC_SGNL_REC_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.DVC_SGNL_REC_RF Bound Attachments |
Name | Current Value |