DVC.DVC_SYS_SUBSYS_DVC_TYPE_IDX |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.DVC_SYS_SUBSYS_DVC_TYPE_IDX ON EPICS.DVC(SYS_ID, SUBSYS_ID, DVC_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.DVC_SYS_SUBSYS_DVC_TYPE_IDX Index Columns |
ColumnName | Sort Order |
SYS_ID | Ascending |
SUBSYS_ID | Ascending |
DVC_TYPE_ID | Ascending |
DVC.DVC_SYS_SUBSYS_DVC_TYPE_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.DVC_SYS_SUBSYS_DVC_TYPE_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_SYS_SUBSYS_DVC_TYPE_IDX Bound Attachments |
Name | Current Value |
DVC.DVC_DVC_TYPE_ID_IDX |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.DVC_DVC_TYPE_ID_IDX ON EPICS.DVC(DVC_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.DVC_DVC_TYPE_ID_IDX Index Columns |
ColumnName | Sort Order |
DVC_TYPE_ID | Ascending |
DVC.DVC_DVC_TYPE_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.DVC_DVC_TYPE_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_DVC_TYPE_ID_IDX Bound Attachments |
Name | Current Value |
DVC.DVC_ID_ALIAS_IDX |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX EPICS.DVC_ID_ALIAS_IDX ON EPICS.DVC(DVC_ID_ALIAS)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.DVC_ID_ALIAS_IDX Index Columns |
ColumnName | Sort Order |
DVC_ID_ALIAS | Ascending |
DVC.DVC_ID_ALIAS_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.DVC_ID_ALIAS_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_ID_ALIAS_IDX Bound Attachments |
Name | Current Value |
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 | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.DEVICE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DEVICE_PK Bound Attachments |
Name | Current Value |
DVC.UPPER_DVC_ID_IDX |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.UPPER_DVC_ID_IDX ON EPICS.DVC(UPPER("DVC_ID"))      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.UPPER_DVC_ID_IDX Index Columns |
ColumnName | Sort Order |
UPPER("DVC_ID") |
DVC.UPPER_DVC_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.UPPER_DVC_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.UPPER_DVC_ID_IDX Bound Attachments |
Name | Current Value |
DVC.PRNT_DVC_ID |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.PRNT_DVC_ID ON EPICS.DVC(PARENT_DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.PRNT_DVC_ID Index Columns |
ColumnName | Sort Order |
PARENT_DVC_ID | Ascending |
DVC.PRNT_DVC_ID Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.PRNT_DVC_ID Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.PRNT_DVC_ID Bound Attachments |
Name | Current Value |
DVC.DVC_SYS_ID_IDX |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.DVC_SYS_ID_IDX ON EPICS.DVC(SYS_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.DVC_SYS_ID_IDX Index Columns |
ColumnName | Sort Order |
SYS_ID | Ascending |
DVC.DVC_SYS_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.DVC_SYS_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_SYS_ID_IDX Bound Attachments |
Name | Current Value |
DVC.DVC_SUBSYS_ID_IDX |
TableName | DVC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.DVC_SUBSYS_ID_IDX ON EPICS.DVC(SUBSYS_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
DVC.DVC_SUBSYS_ID_IDX Index Columns |
ColumnName | Sort Order |
SUBSYS_ID | Ascending |
DVC.DVC_SUBSYS_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
DVC.DVC_SUBSYS_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DVC.DVC_SUBSYS_ID_IDX Bound Attachments |
Name | Current Value |
FLD.IDX_FLD_TYPE_ID_F |
TableName | FLD |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_FLD_TYPE_ID_F ON IRMISBASE.FLD(FLD_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      NOLOGGING      PARALLEL(DEGREE 2 INSTANCES 1)      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
FLD.IDX_FLD_TYPE_ID_F Index Columns |
ColumnName | Sort Order |
FLD_TYPE_ID | Ascending |
FLD.IDX_FLD_TYPE_ID_F Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | YES |
Parallel Degrees | 2 |
Parallel Instances | 1 |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD.IDX_FLD_TYPE_ID_F Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD.IDX_FLD_TYPE_ID_F Bound Attachments |
Name | Current Value |
FLD.IDX_FLD_VAL_F |
TableName | FLD |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_FLD_VAL_F ON IRMISBASE.FLD(FLD_VAL)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
FLD.IDX_FLD_VAL_F Index Columns |
ColumnName | Sort Order |
FLD_VAL | Ascending |
FLD.IDX_FLD_VAL_F Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD.IDX_FLD_VAL_F Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD.IDX_FLD_VAL_F Bound Attachments |
Name | Current Value |
FLD.IDX_IOC_RESOURCE_ID_F |
TableName | FLD |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_RESOURCE_ID_F ON IRMISBASE.FLD(IOC_RESOURCE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
FLD.IDX_IOC_RESOURCE_ID_F Index Columns |
ColumnName | Sort Order |
IOC_RESOURCE_ID | Ascending |
FLD.IDX_IOC_RESOURCE_ID_F Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD.IDX_IOC_RESOURCE_ID_F Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD.IDX_IOC_RESOURCE_ID_F Bound Attachments |
Name | Current Value |
FLD.IDX_REC_ID_F |
TableName | FLD |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_REC_ID_F ON IRMISBASE.FLD(REC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
FLD.IDX_REC_ID_F Index Columns |
ColumnName | Sort Order |
REC_ID | Ascending |
FLD.IDX_REC_ID_F Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD.IDX_REC_ID_F Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD.IDX_REC_ID_F Bound Attachments |
Name | Current Value |
FLD.SYS_C0015455 |
TableName | FLD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FLD.SYS_C0015455 Index Columns |
ColumnName | Sort Order |
FLD_ID | Ascending |
FLD.SYS_C0015455 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD.SYS_C0015455 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD.SYS_C0015455 Bound Attachments |
Name | Current Value |
FLD_TYPE.IDX_DBD_TYPE_FT |
TableName | FLD_TYPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_DBD_TYPE_FT ON IRMISBASE.FLD_TYPE(DBD_TYPE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
FLD_TYPE.IDX_DBD_TYPE_FT Index Columns |
ColumnName | Sort Order |
DBD_TYPE | Ascending |
FLD_TYPE.IDX_DBD_TYPE_FT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD_TYPE.IDX_DBD_TYPE_FT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD_TYPE.IDX_DBD_TYPE_FT Bound Attachments |
Name | Current Value |
FLD_TYPE.IDX_REC_TYPE_ID_FT |
TableName | FLD_TYPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_REC_TYPE_ID_FT ON IRMISBASE.FLD_TYPE(REC_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
FLD_TYPE.IDX_REC_TYPE_ID_FT Index Columns |
ColumnName | Sort Order |
REC_TYPE_ID | Ascending |
FLD_TYPE.IDX_REC_TYPE_ID_FT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD_TYPE.IDX_REC_TYPE_ID_FT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD_TYPE.IDX_REC_TYPE_ID_FT Bound Attachments |
Name | Current Value |
FLD_TYPE.SYS_C0015459 |
TableName | FLD_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FLD_TYPE.SYS_C0015459 Index Columns |
ColumnName | Sort Order |
FLD_TYPE_ID | Ascending |
FLD_TYPE.SYS_C0015459 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
FLD_TYPE.SYS_C0015459 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FLD_TYPE.SYS_C0015459 Bound Attachments |
Name | Current Value |
IOC.SYS_C0015441 |
TableName | IOC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IOC.SYS_C0015441 Index Columns |
ColumnName | Sort Order |
IOC_ID | Ascending |
IOC.SYS_C0015441 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC.SYS_C0015441 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC.SYS_C0015441 Bound Attachments |
Name | Current Value |
IOC_BOOT.IDX_CURRENT_LOAD_IB |
TableName | IOC_BOOT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_CURRENT_LOAD_IB ON IRMISBASE.IOC_BOOT(CURRENT_LOAD)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
IOC_BOOT.IDX_CURRENT_LOAD_IB Index Columns |
ColumnName | Sort Order |
CURRENT_LOAD | Ascending |
IOC_BOOT.IDX_CURRENT_LOAD_IB Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_BOOT.IDX_CURRENT_LOAD_IB Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_BOOT.IDX_CURRENT_LOAD_IB Bound Attachments |
Name | Current Value |
IOC_BOOT.IDX_IOC_ID_IB |
TableName | IOC_BOOT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_ID_IB ON IRMISBASE.IOC_BOOT(IOC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
IOC_BOOT.IDX_IOC_ID_IB Index Columns |
ColumnName | Sort Order |
IOC_ID | Ascending |
IOC_BOOT.IDX_IOC_ID_IB Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_BOOT.IDX_IOC_ID_IB Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_BOOT.IDX_IOC_ID_IB Bound Attachments |
Name | Current Value |
IOC_BOOT.SYS_C0015447 |
TableName | IOC_BOOT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IOC_BOOT.SYS_C0015447 Index Columns |
ColumnName | Sort Order |
IOC_BOOT_ID | Ascending |
IOC_BOOT.SYS_C0015447 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_BOOT.SYS_C0015447 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_BOOT.SYS_C0015447 Bound Attachments |
Name | Current Value |
IOC_ERROR.IDX_IOC_BOOT_ID_IE |
TableName | IOC_ERROR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_BOOT_ID_IE ON IRMISBASE.IOC_ERROR(IOC_BOOT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
IOC_ERROR.IDX_IOC_BOOT_ID_IE Index Columns |
ColumnName | Sort Order |
IOC_BOOT_ID | Ascending |
IOC_ERROR.IDX_IOC_BOOT_ID_IE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_ERROR.IDX_IOC_BOOT_ID_IE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_ERROR.IDX_IOC_BOOT_ID_IE Bound Attachments |
Name | Current Value |
IOC_ERROR.SYS_C0015449 |
TableName | IOC_ERROR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IOC_ERROR.SYS_C0015449 Index Columns |
ColumnName | Sort Order |
IOC_ERROR_ID | Ascending |
IOC_ERROR.SYS_C0015449 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_ERROR.SYS_C0015449 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_ERROR.SYS_C0015449 Bound Attachments |
Name | Current Value |
IOC_ERROR_MESSAGE.SYS_C0015415 |
TableName | IOC_ERROR_MESSAGE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IOC_ERROR_MESSAGE.SYS_C0015415 Index Columns |
ColumnName | Sort Order |
IOC_ERROR_NUM | Ascending |
IOC_ERROR_MESSAGE.SYS_C0015415 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_ERROR_MESSAGE.SYS_C0015415 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_ERROR_MESSAGE.SYS_C0015415 Bound Attachments |
Name | Current Value |
IOC_RESOURCE.IDX_IOC_BOOT_ID_IR |
TableName | IOC_RESOURCE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_BOOT_ID_IR ON IRMISBASE.IOC_RESOURCE(IOC_BOOT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
IOC_RESOURCE.IDX_IOC_BOOT_ID_IR Index Columns |
ColumnName | Sort Order |
IOC_BOOT_ID | Ascending |
IOC_RESOURCE.IDX_IOC_BOOT_ID_IR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_RESOURCE.IDX_IOC_BOOT_ID_IR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_RESOURCE.IDX_IOC_BOOT_ID_IR Bound Attachments |
Name | Current Value |
IOC_RESOURCE.IDX_URI_ID_IR |
TableName | IOC_RESOURCE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_URI_ID_IR ON IRMISBASE.IOC_RESOURCE(URI_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
IOC_RESOURCE.IDX_URI_ID_IR Index Columns |
ColumnName | Sort Order |
URI_ID | Ascending |
IOC_RESOURCE.IDX_URI_ID_IR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_RESOURCE.IDX_URI_ID_IR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_RESOURCE.IDX_URI_ID_IR Bound Attachments |
Name | Current Value |
IOC_RESOURCE.SYS_C0015451 |
TableName | IOC_RESOURCE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IOC_RESOURCE.SYS_C0015451 Index Columns |
ColumnName | Sort Order |
IOC_RESOURCE_ID | Ascending |
IOC_RESOURCE.SYS_C0015451 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
IOC_RESOURCE.SYS_C0015451 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_RESOURCE.SYS_C0015451 Bound Attachments |
Name | Current Value |
REC.IDX_IOC_BOOT_ID_R |
TableName | REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_BOOT_ID_R ON IRMISBASE.REC(IOC_BOOT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
REC.IDX_IOC_BOOT_ID_R Index Columns |
ColumnName | Sort Order |
IOC_BOOT_ID | Ascending |
REC.IDX_IOC_BOOT_ID_R Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC.IDX_IOC_BOOT_ID_R Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC.IDX_IOC_BOOT_ID_R Bound Attachments |
Name | Current Value |
REC.IDX_REC_NM_R |
TableName | REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_REC_NM_R ON IRMISBASE.REC(REC_NM)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
REC.IDX_REC_NM_R Index Columns |
ColumnName | Sort Order |
REC_NM | Ascending |
REC.IDX_REC_NM_R Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC.IDX_REC_NM_R Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC.IDX_REC_NM_R Bound Attachments |
Name | Current Value |
REC.IDX_REC_TYPE_ID_R |
TableName | REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_REC_TYPE_ID_R ON IRMISBASE.REC(REC_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
REC.IDX_REC_TYPE_ID_R Index Columns |
ColumnName | Sort Order |
REC_TYPE_ID | Ascending |
REC.IDX_REC_TYPE_ID_R Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC.IDX_REC_TYPE_ID_R Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC.IDX_REC_TYPE_ID_R Bound Attachments |
Name | Current Value |
REC.SYS_C0015453 |
TableName | REC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REC.SYS_C0015453 Index Columns |
ColumnName | Sort Order |
REC_ID | Ascending |
REC.SYS_C0015453 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC.SYS_C0015453 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC.SYS_C0015453 Bound Attachments |
Name | Current Value |
REC_TYPE.IDX_IOC_BOOT_ID_RT |
TableName | REC_TYPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_BOOT_ID_RT ON IRMISBASE.REC_TYPE(IOC_BOOT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
REC_TYPE.IDX_IOC_BOOT_ID_RT Index Columns |
ColumnName | Sort Order |
IOC_BOOT_ID | Ascending |
REC_TYPE.IDX_IOC_BOOT_ID_RT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC_TYPE.IDX_IOC_BOOT_ID_RT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC_TYPE.IDX_IOC_BOOT_ID_RT Bound Attachments |
Name | Current Value |
REC_TYPE.IDX_IOC_RESOURCE_ID_RT |
TableName | REC_TYPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_IOC_RESOURCE_ID_RT ON IRMISBASE.REC_TYPE(IOC_RESOURCE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
REC_TYPE.IDX_IOC_RESOURCE_ID_RT Index Columns |
ColumnName | Sort Order |
IOC_RESOURCE_ID | Ascending |
REC_TYPE.IDX_IOC_RESOURCE_ID_RT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC_TYPE.IDX_IOC_RESOURCE_ID_RT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC_TYPE.IDX_IOC_RESOURCE_ID_RT Bound Attachments |
Name | Current Value |
REC_TYPE.IDX_REC_TYPE_ID_RT |
TableName | REC_TYPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX IRMISBASE.IDX_REC_TYPE_ID_RT ON IRMISBASE.REC_TYPE(REC_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
REC_TYPE.IDX_REC_TYPE_ID_RT Index Columns |
ColumnName | Sort Order |
REC_TYPE_ID | Ascending |
REC_TYPE.IDX_REC_TYPE_ID_RT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
REC_TYPE.IDX_REC_TYPE_ID_RT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC_TYPE.IDX_REC_TYPE_ID_RT Bound Attachments |
Name | Current Value |
REC_TYPE.SYS_C0015457 |
TableName | REC_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REC_TYPE.SYS_C0015457 Index Columns |
ColumnName | Sort Order |
REC_TYPE_ID | Ascending |
REC_TYPE.SYS_C0015457 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 |
REC_TYPE.SYS_C0015457 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REC_TYPE.SYS_C0015457 Bound Attachments |
Name | Current Value |
SGNL_REC.SGNL_ID_ALIAS_IDX |
TableName | SGNL_REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX EPICS.SGNL_ID_ALIAS_IDX ON EPICS.SGNL_REC(SGNL_ID_ALIAS)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
SGNL_REC.SGNL_ID_ALIAS_IDX Index Columns |
ColumnName | Sort Order |
SGNL_ID_ALIAS | Ascending |
SGNL_REC.SGNL_ID_ALIAS_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
SGNL_REC.SGNL_ID_ALIAS_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.SGNL_ID_ALIAS_IDX 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 | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
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.SGNL_REC_DVC_ID_IDX |
TableName | SGNL_REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.SGNL_REC_DVC_ID_IDX ON EPICS.SGNL_REC(DVC_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
SGNL_REC.SGNL_REC_DVC_ID_IDX Index Columns |
ColumnName | Sort Order |
DVC_ID | Ascending |
SGNL_REC.SGNL_REC_DVC_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
SGNL_REC.SGNL_REC_DVC_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.SGNL_REC_DVC_ID_IDX Bound Attachments |
Name | Current Value |
SGNL_REC.SGNL_NM_IDX |
TableName | SGNL_REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.SGNL_NM_IDX ON EPICS.SGNL_REC(SGNL_NM)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
SGNL_REC.SGNL_NM_IDX Index Columns |
ColumnName | Sort Order |
SGNL_NM | Ascending |
SGNL_REC.SGNL_NM_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
SGNL_REC.SGNL_NM_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.SGNL_NM_IDX Bound Attachments |
Name | Current Value |
SGNL_REC_MV.IDX_REC_NM |
TableName | SGNL_REC_MV |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_REC_NM ON IRMISBASE.SGNL_REC_MV(REC_NM)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
SGNL_REC_MV.IDX_REC_NM Index Columns |
ColumnName | Sort Order |
REC_NM | Ascending |
SGNL_REC_MV.IDX_REC_NM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
SGNL_REC_MV.IDX_REC_NM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC_MV.IDX_REC_NM Bound Attachments |
Name | Current Value |
SGNL_REC_MV.I_SNAP$_SGNL_REC_MV |
TableName | SGNL_REC_MV |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX IRMISBASE.I_SNAP$_SGNL_REC_MV ON IRMISBASE.SGNL_REC_MV(SYS_OP_MAP_NONNULL("REC_NM"), SYS_OP_MAP_NONNULL("REC_TYPE"))      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Index Columns |
ColumnName | Sort Order |
SYS_OP_MAP_NONNULL("REC_NM") | |
SYS_OP_MAP_NONNULL("REC_TYPE") |
SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Bound Attachments |
Name | Current Value |
SGNL_REC_TYPE.SGNL_REC_TYPE_PK |
TableName | SGNL_REC_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SGNL_REC_TYPE.SGNL_REC_TYPE_PK Index Columns |
ColumnName | Sort Order |
REC_TYPE_ID | Ascending |
SGNL_REC_TYPE.SGNL_REC_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 120 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
SGNL_REC_TYPE.SGNL_REC_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC_TYPE.SGNL_REC_TYPE_PK Bound Attachments |
Name | Current Value |
URI.IDX_URI_FILE_NAME |
TableName | URI |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IRMISBASE.IDX_URI_FILE_NAME ON IRMISBASE.URI(FILE_NAME)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
URI.IDX_URI_FILE_NAME Index Columns |
ColumnName | Sort Order |
FILE_NAME | Ascending |
URI.IDX_URI_FILE_NAME Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
URI.IDX_URI_FILE_NAME Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
URI.IDX_URI_FILE_NAME Bound Attachments |
Name | Current Value |
URI.SYS_C0015439 |
TableName | URI |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
URI.SYS_C0015439 Index Columns |
ColumnName | Sort Order |
URI_ID | Ascending |
URI.SYS_C0015439 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
URI.SYS_C0015439 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
URI.SYS_C0015439 Bound Attachments |
Name | Current Value |