| BARCD_ASGN.BARCD_ASGN_PK |
| TableName | BARCD_ASGN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BARCD_ASGN.BARCD_ASGN_PK Index Columns |
| ColumnName | Sort Order |
| DVC_IEEE_NM | Ascending |
| BARCD_ASGN.BARCD_ASGN_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BARCD_ASGN.BARCD_ASGN_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BARCD_ASGN.BARCD_ASGN_PK Bound Attachments |
| Name | Current Value |
| BARCD_ASGN_AUDIT.BARCD_ASGN_AUDIT_PK |
| TableName | BARCD_ASGN_AUDIT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BARCD_ASGN_AUDIT.BARCD_ASGN_AUDIT_PK Index Columns |
| ColumnName | Sort Order |
| DVC_IEEE_NM | Ascending |
| ASSGN_DTE | Ascending |
| BARCD_ASGN_AUDIT.BARCD_ASGN_AUDIT_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BARCD_ASGN_AUDIT.BARCD_ASGN_AUDIT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BARCD_ASGN_AUDIT.BARCD_ASGN_AUDIT_PK Bound Attachments |
| Name | Current Value |
| BARCD_ASGN_AUDIT.BARCD_ASGN_BARCD_ASGN_AUDIT_RF |
| TableName | BARCD_ASGN_AUDIT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX BARCD_ASGN_BARCD_ASGN_AUDIT_RF ON BARCD_ASGN_AUDIT(DVC_IEEE_NM) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BARCD_ASGN_AUDIT.BARCD_ASGN_BARCD_ASGN_AUDIT_RF Index Columns |
| ColumnName | Sort Order |
| DVC_IEEE_NM | Ascending |
| BARCD_ASGN_AUDIT.BARCD_ASGN_BARCD_ASGN_AUDIT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BARCD_ASGN_AUDIT.BARCD_ASGN_BARCD_ASGN_AUDIT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BARCD_ASGN_AUDIT.BARCD_ASGN_BARCD_ASGN_AUDIT_RF Bound Attachments |
| Name | Current Value |
| BEAD_PULL.PK375 |
| TableName | BEAD_PULL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAD_PULL.PK375 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| BEAD_PULL.PK375 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAD_PULL.PK375 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAD_PULL.PK375 Bound Attachments |
| Name | Current Value |
| BEAD_PULL.Ref373668 |
| TableName | BEAD_PULL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref373668 ON BEAD_PULL(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BEAD_PULL.Ref373668 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| BEAD_PULL.Ref373668 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAD_PULL.Ref373668 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAD_PULL.Ref373668 Bound Attachments |
| Name | Current Value |
| BLDG.BLDG_PK |
| TableName | BLDG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BLDG.BLDG_PK Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| BLDG.BLDG_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BLDG.BLDG_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLDG.BLDG_PK Bound Attachments |
| Name | Current Value |
| BLDG_AREA.BLDG_AREA_PK |
| TableName | BLDG_AREA |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BLDG_AREA.BLDG_AREA_PK Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| AREA_ID | Ascending |
| BLDG_AREA.BLDG_AREA_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BLDG_AREA.BLDG_AREA_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLDG_AREA.BLDG_AREA_PK Bound Attachments |
| Name | Current Value |
| BLDG_AREA.BLDG_CODE_RF |
| TableName | BLDG_AREA |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX BLDG_CODE_RF ON BLDG_AREA(BLDG_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLDG_AREA.BLDG_CODE_RF Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| BLDG_AREA.BLDG_CODE_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BLDG_AREA.BLDG_CODE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLDG_AREA.BLDG_CODE_RF Bound Attachments |
| Name | Current Value |
| BLDG_AREA.BLDG_CODE_RF |
| TableName | BLDG_AREA |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX BLDG_CODE_RF ON BLDG_AREA(BLDG_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLDG_AREA.BLDG_CODE_RF Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| BLDG_AREA.BLDG_CODE_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BLDG_AREA.BLDG_CODE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLDG_AREA.BLDG_CODE_RF Bound Attachments |
| Name | Current Value |
| BLDG_SUBAREA.BLDG_SUBAREA_PK |
| TableName | BLDG_SUBAREA |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BLDG_SUBAREA.BLDG_SUBAREA_PK Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| AREA_ID | Ascending |
| SUBAREA_ID | Ascending |
| BLDG_SUBAREA.BLDG_SUBAREA_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BLDG_SUBAREA.BLDG_SUBAREA_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLDG_SUBAREA.BLDG_SUBAREA_PK Bound Attachments |
| Name | Current Value |
| BLDG_SUBAREA.BLDG_AREA_BLDG_SUBAREA_RF |
| TableName | BLDG_SUBAREA |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX BLDG_AREA_BLDG_SUBAREA_RF ON BLDG_SUBAREA(BLDG_ID, AREA_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLDG_SUBAREA.BLDG_AREA_BLDG_SUBAREA_RF Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| AREA_ID | Ascending |
| BLDG_SUBAREA.BLDG_AREA_BLDG_SUBAREA_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BLDG_SUBAREA.BLDG_AREA_BLDG_SUBAREA_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLDG_SUBAREA.BLDG_AREA_BLDG_SUBAREA_RF Bound Attachments |
| Name | Current Value |
| CALIB_FREQ.CALIB_FREQ_PK |
| TableName | CALIB_FREQ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CALIB_FREQ.CALIB_FREQ_PK Index Columns |
| ColumnName | Sort Order |
| CALIB_FREQ_ID | Ascending |
| CALIB_FREQ.CALIB_FREQ_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CALIB_FREQ.CALIB_FREQ_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CALIB_FREQ.CALIB_FREQ_PK Bound Attachments |
| Name | Current Value |
| CALIB_METHOD.CALIB_METHOD_PK |
| TableName | CALIB_METHOD |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CALIB_METHOD.CALIB_METHOD_PK Index Columns |
| ColumnName | Sort Order |
| CALIB_METHOD_ID | Ascending |
| CALIB_METHOD.CALIB_METHOD_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CALIB_METHOD.CALIB_METHOD_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CALIB_METHOD.CALIB_METHOD_PK Bound Attachments |
| Name | Current Value |
| CARRIER.CARRIER_PK |
| TableName | CARRIER |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CARRIER.CARRIER_PK Index Columns |
| ColumnName | Sort Order |
| CARRIER_ID | Ascending |
| CARRIER.CARRIER_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CARRIER.CARRIER_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CARRIER.CARRIER_PK Bound Attachments |
| Name | Current Value |
| CTRLS_MNFCTR_MDL.SGNL_MNFCTR_MDL_PK |
| TableName | CTRLS_MNFCTR_MDL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRLS_MNFCTR_MDL.SGNL_MNFCTR_MDL_PK Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| CTRLS_MNFCTR_MDL.SGNL_MNFCTR_MDL_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRLS_MNFCTR_MDL.SGNL_MNFCTR_MDL_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRLS_MNFCTR_MDL.SGNL_MNFCTR_MDL_PK Bound Attachments |
| Name | Current Value |
| CTRLS_MNFCTR_MDL.Ref86220 |
| TableName | CTRLS_MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref86220 ON CTRLS_MNFCTR_MDL(MDL_NBR, MNFCTR_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| CTRLS_MNFCTR_MDL.Ref86220 Index Columns |
| ColumnName | Sort Order |
| MDL_NBR | Ascending |
| MNFCTR_ID | Ascending |
| CTRLS_MNFCTR_MDL.Ref86220 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRLS_MNFCTR_MDL.Ref86220 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRLS_MNFCTR_MDL.Ref86220 Bound Attachments |
| Name | Current Value |
| DIAG_EQUIP_HIST.PK_DIAG_EQUIP_HIST |
| TableName | DIAG_EQUIP_HIST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DIAG_EQUIP_HIST.PK_DIAG_EQUIP_HIST Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| MOD_DTE | Ascending |
| DIAG_EQUIP_HIST.PK_DIAG_EQUIP_HIST 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DIAG_EQUIP_HIST.PK_DIAG_EQUIP_HIST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIAG_EQUIP_HIST.PK_DIAG_EQUIP_HIST Bound Attachments |
| Name | Current Value |
| DIAG_EQUIP_HIST.Ref9871 |
| TableName | DIAG_EQUIP_HIST |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref9871 ON DIAG_EQUIP_HIST(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DIAG_EQUIP_HIST.Ref9871 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| DIAG_EQUIP_HIST.Ref9871 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DIAG_EQUIP_HIST.Ref9871 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIAG_EQUIP_HIST.Ref9871 Bound Attachments |
| Name | Current Value |
| EMPLOYEE_MV.EMPLOYEE_PK |
| TableName | EMPLOYEE_MV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMPLOYEE_MV.EMPLOYEE_PK Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| EMPLOYEE_MV.EMPLOYEE_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMPLOYEE_MV.EMPLOYEE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMPLOYEE_MV.EMPLOYEE_PK Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_PK |
| TableName | EQUIP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP.EQUIP_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP.EQUIP_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_PK Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_TYPE_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_TYPE_RF ON EQUIP(EQUIP_CAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.EQUIP_TYPE_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP.EQUIP_TYPE_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_TYPE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_TYPE_RF Bound Attachments |
| Name | Current Value |
| EQUIP.PARENT_EQUIP_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PARENT_EQUIP_RF ON EQUIP(PARENT_EQUIPMENT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.PARENT_EQUIP_RF Index Columns |
| ColumnName | Sort Order |
| PARENT_EQUIPMENT_ID | Ascending |
| EQUIP.PARENT_EQUIP_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.PARENT_EQUIP_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.PARENT_EQUIP_RF Bound Attachments |
| Name | Current Value |
| EQUIP.MNFCTR_MDL_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX MNFCTR_MDL_RF ON EQUIP(MNFCTR_ID, MDL_NBR) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.MNFCTR_MDL_RF Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| EQUIP.MNFCTR_MDL_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.MNFCTR_MDL_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.MNFCTR_MDL_RF Bound Attachments |
| Name | Current Value |
| EQUIP.PARENT_EQUIP_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PARENT_EQUIP_RF ON EQUIP(PARENT_EQUIPMENT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.PARENT_EQUIP_RF Index Columns |
| ColumnName | Sort Order |
| PARENT_EQUIPMENT_ID | Ascending |
| EQUIP.PARENT_EQUIP_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.PARENT_EQUIP_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.PARENT_EQUIP_RF Bound Attachments |
| Name | Current Value |
| EQUIP.MNFCTR_MDL_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX MNFCTR_MDL_RF ON EQUIP(MNFCTR_ID, MDL_NBR) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.MNFCTR_MDL_RF Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| EQUIP.MNFCTR_MDL_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.MNFCTR_MDL_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.MNFCTR_MDL_RF Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_LEAD_ENG_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_LEAD_ENG_RF ON EQUIP(LEAD_ENG_BN) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.EQUIP_LEAD_ENG_RF Index Columns |
| ColumnName | Sort Order |
| LEAD_ENG_BN | Ascending |
| EQUIP.EQUIP_LEAD_ENG_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_LEAD_ENG_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_LEAD_ENG_RF Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_CALIB_METHOD_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_CALIB_METHOD_RF ON EQUIP(CALIB_METHOD_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.EQUIP_CALIB_METHOD_RF Index Columns |
| ColumnName | Sort Order |
| CALIB_METHOD_ID | Ascending |
| EQUIP.EQUIP_CALIB_METHOD_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_CALIB_METHOD_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_CALIB_METHOD_RF Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_CALIB_FREQ_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_CALIB_FREQ_RF ON EQUIP(CALIB_FREQ_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.EQUIP_CALIB_FREQ_RF Index Columns |
| ColumnName | Sort Order |
| CALIB_FREQ_ID | Ascending |
| EQUIP.EQUIP_CALIB_FREQ_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_CALIB_FREQ_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_CALIB_FREQ_RF Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_EQUIP_SUBCAT_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_EQUIP_SUBCAT_RF ON EQUIP(EQUIP_CAT_ID, EQUIP_SUBCAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.EQUIP_EQUIP_SUBCAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_SUBCAT_ID | Ascending |
| EQUIP.EQUIP_EQUIP_SUBCAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_EQUIP_SUBCAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_EQUIP_SUBCAT_RF Bound Attachments |
| Name | Current Value |
| EQUIP.EQUIP_EQUIP_SUB_SUBCAT_RF |
| TableName | EQUIP |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_EQUIP_SUB_SUBCAT_RF ON EQUIP(EQUIP_SUBCAT_ID, EQUIP_SUB_SUBCAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP.EQUIP_EQUIP_SUB_SUBCAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_SUBCAT_ID | Ascending |
| EQUIP_SUB_SUBCAT_ID | Ascending |
| EQUIP.EQUIP_EQUIP_SUB_SUBCAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP.EQUIP_EQUIP_SUB_SUBCAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP.EQUIP_EQUIP_SUB_SUBCAT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_CAT.EQUIP_CAT_PK |
| TableName | EQUIP_CAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_CAT.EQUIP_CAT_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_CAT.EQUIP_CAT_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_CAT.EQUIP_CAT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_CAT.EQUIP_CAT_PK Bound Attachments |
| Name | Current Value |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN_PK |
| TableName | EQUIP_DVC_ASGN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN_PK Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| EQUIP_ID | Ascending |
| ASGN_BDTE | Ascending |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN_PK Bound Attachments |
| Name | Current Value |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF |
| TableName | EQUIP_DVC_ASGN |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_DVC_ASGN2_RF ON EQUIP_DVC_ASGN(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF Bound Attachments |
| Name | Current Value |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF |
| TableName | EQUIP_DVC_ASGN |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_DVC_ASGN2_RF ON EQUIP_DVC_ASGN(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_DVC_ASGN.EQUIP_DVC_ASGN2_RF Bound Attachments |
| Name | Current Value |
| EQUIP_LOC.EQUIP_LOC_PK |
| TableName | EQUIP_LOC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_LOC.EQUIP_LOC_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| BDTE | Ascending |
| EQUIP_LOC.EQUIP_LOC_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_LOC.EQUIP_LOC_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_LOC.EQUIP_LOC_PK Bound Attachments |
| Name | Current Value |
| EQUIP_LOC.AREA_EQUIP_RF |
| TableName | EQUIP_LOC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX AREA_EQUIP_RF ON EQUIP_LOC(AREA_ID, BLDG_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_LOC.AREA_EQUIP_RF Index Columns |
| ColumnName | Sort Order |
| AREA_ID | Ascending |
| BLDG_ID | Ascending |
| EQUIP_LOC.AREA_EQUIP_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_LOC.AREA_EQUIP_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_LOC.AREA_EQUIP_RF Bound Attachments |
| Name | Current Value |
| EQUIP_LOC.EQUIP_RF |
| TableName | EQUIP_LOC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_RF ON EQUIP_LOC(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_LOC.EQUIP_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_LOC.EQUIP_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_LOC.EQUIP_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_LOC.EQUIP_RF Bound Attachments |
| Name | Current Value |
| EQUIP_LOC.EQUIP_LOC_RF |
| TableName | EQUIP_LOC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_LOC_RF ON EQUIP_LOC(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_LOC.EQUIP_LOC_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_LOC.EQUIP_LOC_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_LOC.EQUIP_LOC_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_LOC.EQUIP_LOC_RF Bound Attachments |
| Name | Current Value |
| EQUIP_LOC.AREA_EQUIP_LOC_RF |
| TableName | EQUIP_LOC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX AREA_EQUIP_LOC_RF ON EQUIP_LOC(BLDG_ID, AREA_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_LOC.AREA_EQUIP_LOC_RF Index Columns |
| ColumnName | Sort Order |
| BLDG_ID | Ascending |
| AREA_ID | Ascending |
| EQUIP_LOC.AREA_EQUIP_LOC_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_LOC.AREA_EQUIP_LOC_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_LOC.AREA_EQUIP_LOC_RF Bound Attachments |
| Name | Current Value |
| EQUIP_RCPT.EQUP_RCPT_PK |
| TableName | EQUIP_RCPT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_RCPT.EQUP_RCPT_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_RCPT_ID | Ascending |
| EQUIP_RCPT_VER | Ascending |
| EQUIP_RCPT.EQUP_RCPT_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_RCPT.EQUP_RCPT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_RCPT.EQUP_RCPT_PK Bound Attachments |
| Name | Current Value |
| EQUIP_RCPT.CARRIER_RCPT_RF |
| TableName | EQUIP_RCPT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CARRIER_RCPT_RF ON EQUIP_RCPT(CARRIER_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_RCPT.CARRIER_RCPT_RF Index Columns |
| ColumnName | Sort Order |
| CARRIER_ID | Ascending |
| EQUIP_RCPT.CARRIER_RCPT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_RCPT.CARRIER_RCPT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_RCPT.CARRIER_RCPT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_RCPT.CARRIER_RCPT_RF |
| TableName | EQUIP_RCPT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CARRIER_RCPT_RF ON EQUIP_RCPT(CARRIER_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_RCPT.CARRIER_RCPT_RF Index Columns |
| ColumnName | Sort Order |
| CARRIER_ID | Ascending |
| EQUIP_RCPT.CARRIER_RCPT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_RCPT.CARRIER_RCPT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_RCPT.CARRIER_RCPT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_RCPT.EQUP_RCPT_RCVD_BY_RF |
| TableName | EQUIP_RCPT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUP_RCPT_RCVD_BY_RF ON EQUIP_RCPT(RCVD_BY_BN) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_RCPT.EQUP_RCPT_RCVD_BY_RF Index Columns |
| ColumnName | Sort Order |
| RCVD_BY_BN | Ascending |
| EQUIP_RCPT.EQUP_RCPT_RCVD_BY_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_RCPT.EQUP_RCPT_RCVD_BY_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_RCPT.EQUP_RCPT_RCVD_BY_RF Bound Attachments |
| Name | Current Value |
| EQUIP_RCPT.EQUP_RCPT_LAB_RF |
| TableName | EQUIP_RCPT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUP_RCPT_LAB_RF ON EQUIP_RCPT(LAB_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_RCPT.EQUP_RCPT_LAB_RF Index Columns |
| ColumnName | Sort Order |
| LAB_ID | Ascending |
| EQUIP_RCPT.EQUP_RCPT_LAB_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_RCPT.EQUP_RCPT_LAB_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_RCPT.EQUP_RCPT_LAB_RF Bound Attachments |
| Name | Current Value |
| EQUIP_RCPT.EQUP_RCPT_LEAD_ENG_RF |
| TableName | EQUIP_RCPT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUP_RCPT_LEAD_ENG_RF ON EQUIP_RCPT(LEAD_ENG_BN) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_RCPT.EQUP_RCPT_LEAD_ENG_RF Index Columns |
| ColumnName | Sort Order |
| LEAD_ENG_BN | Ascending |
| EQUIP_RCPT.EQUP_RCPT_LEAD_ENG_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_RCPT.EQUP_RCPT_LEAD_ENG_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_RCPT.EQUP_RCPT_LEAD_ENG_RF Bound Attachments |
| Name | Current Value |
| EQUIP_STAT.EQUIP_STAT_PK |
| TableName | EQUIP_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_STAT.EQUIP_STAT_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| STAT_DTE | Ascending |
| EQUIP_STAT.EQUIP_STAT_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_STAT.EQUIP_STAT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_STAT.EQUIP_STAT_PK Bound Attachments |
| Name | Current Value |
| EQUIP_STAT.EQUIP_STAT_RF |
| TableName | EQUIP_STAT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_STAT_RF ON EQUIP_STAT(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_STAT.EQUIP_STAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_STAT.EQUIP_STAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_STAT.EQUIP_STAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_STAT.EQUIP_STAT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_STAT.EQUIP_STAT_CD_RF |
| TableName | EQUIP_STAT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_STAT_CD_RF ON EQUIP_STAT(EQUIP_STAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_STAT.EQUIP_STAT_CD_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_STAT_ID | Ascending |
| EQUIP_STAT.EQUIP_STAT_CD_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_STAT.EQUIP_STAT_CD_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_STAT.EQUIP_STAT_CD_RF Bound Attachments |
| Name | Current Value |
| EQUIP_STAT.EQUIP_STAT_RF |
| TableName | EQUIP_STAT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_STAT_RF ON EQUIP_STAT(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_STAT.EQUIP_STAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_STAT.EQUIP_STAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_STAT.EQUIP_STAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_STAT.EQUIP_STAT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_STAT.EQUIP_STAT_CD_RF |
| TableName | EQUIP_STAT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_STAT_CD_RF ON EQUIP_STAT(EQUIP_STAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_STAT.EQUIP_STAT_CD_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_STAT_ID | Ascending |
| EQUIP_STAT.EQUIP_STAT_CD_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_STAT.EQUIP_STAT_CD_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_STAT.EQUIP_STAT_CD_RF Bound Attachments |
| Name | Current Value |
| EQUIP_STAT_CODE.EQUIP_STAT_CODE_PK |
| TableName | EQUIP_STAT_CODE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_STAT_CODE.EQUIP_STAT_CODE_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_STAT_ID | Ascending |
| EQUIP_STAT_CODE.EQUIP_STAT_CODE_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_STAT_CODE.EQUIP_STAT_CODE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_STAT_CODE.EQUIP_STAT_CODE_PK Bound Attachments |
| Name | Current Value |
| EQUIP_SUB_SUBCAT.EQUIP_SUB_SUBCAT_PK |
| TableName | EQUIP_SUB_SUBCAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_SUB_SUBCAT.EQUIP_SUB_SUBCAT_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_SUBCAT_ID | Ascending |
| EQUIP_SUB_SUBCAT_ID | Ascending |
| EQUIP_SUB_SUBCAT.EQUIP_SUB_SUBCAT_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_SUB_SUBCAT.EQUIP_SUB_SUBCAT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_SUB_SUBCAT.EQUIP_SUB_SUBCAT_PK Bound Attachments |
| Name | Current Value |
| EQUIP_SUB_SUBCAT.EQUIP_SUBCAT_SUB_SUBCAT_RF |
| TableName | EQUIP_SUB_SUBCAT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_SUBCAT_SUB_SUBCAT_RF ON EQUIP_SUB_SUBCAT(EQUIP_CAT_ID, EQUIP_SUBCAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_SUB_SUBCAT.EQUIP_SUBCAT_SUB_SUBCAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_SUBCAT_ID | Ascending |
| EQUIP_SUB_SUBCAT.EQUIP_SUBCAT_SUB_SUBCAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_SUB_SUBCAT.EQUIP_SUBCAT_SUB_SUBCAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_SUB_SUBCAT.EQUIP_SUBCAT_SUB_SUBCAT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_SUBCAT.EQUIP_SUBCAT_PK |
| TableName | EQUIP_SUBCAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_SUBCAT.EQUIP_SUBCAT_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_SUBCAT_ID | Ascending |
| EQUIP_SUBCAT.EQUIP_SUBCAT_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_SUBCAT.EQUIP_SUBCAT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_SUBCAT.EQUIP_SUBCAT_PK Bound Attachments |
| Name | Current Value |
| EQUIP_SUBCAT.EQUIP_CAT_EQUIP_SUBCAT_RF |
| TableName | EQUIP_SUBCAT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_CAT_EQUIP_SUBCAT_RF ON EQUIP_SUBCAT(EQUIP_CAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_SUBCAT.EQUIP_CAT_EQUIP_SUBCAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_SUBCAT.EQUIP_CAT_EQUIP_SUBCAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_SUBCAT.EQUIP_CAT_EQUIP_SUBCAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_SUBCAT.EQUIP_CAT_EQUIP_SUBCAT_RF Bound Attachments |
| Name | Current Value |
| EQUIP_USAGE.EQUIP_USAGE_PK |
| TableName | EQUIP_USAGE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_USAGE.EQUIP_USAGE_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| USAGE_STRT_DTE | Ascending |
| EQUIP_USAGE.EQUIP_USAGE_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_USAGE.EQUIP_USAGE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_USAGE.EQUIP_USAGE_PK Bound Attachments |
| Name | Current Value |
| EQUIP_USAGE.EMPLOYEE_EQUIP_USAGE_RF |
| TableName | EQUIP_USAGE |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EMPLOYEE_EQUIP_USAGE_RF ON EQUIP_USAGE(BN) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_USAGE.EMPLOYEE_EQUIP_USAGE_RF Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| EQUIP_USAGE.EMPLOYEE_EQUIP_USAGE_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_USAGE.EMPLOYEE_EQUIP_USAGE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_USAGE.EMPLOYEE_EQUIP_USAGE_RF Bound Attachments |
| Name | Current Value |
| EQUIP_USAGE.Ref9326 |
| TableName | EQUIP_USAGE |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref9326 ON EQUIP_USAGE(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| EQUIP_USAGE.Ref9326 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| EQUIP_USAGE.Ref9326 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_USAGE.Ref9326 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_USAGE.Ref9326 Bound Attachments |
| Name | Current Value |
| INSTR.INSTR_PK |
| TableName | INSTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR.INSTR_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| INSTR.INSTR_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR.INSTR_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR.INSTR_PK Bound Attachments |
| Name | Current Value |
| LAB.LAB_PK |
| TableName | LAB |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| LAB.LAB_PK Index Columns |
| ColumnName | Sort Order |
| LAB_ID | Ascending |
| LAB.LAB_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| LAB.LAB_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| LAB.LAB_PK Bound Attachments |
| Name | Current Value |
| LEAD_ENG.LEAD_ENG_PK |
| TableName | LEAD_ENG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| LEAD_ENG.LEAD_ENG_PK Index Columns |
| ColumnName | Sort Order |
| LEAD_ENG_BN | Ascending |
| LEAD_ENG.LEAD_ENG_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| LEAD_ENG.LEAD_ENG_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| LEAD_ENG.LEAD_ENG_PK Bound Attachments |
| Name | Current Value |
| MAG_MNFCTR_MDL.MAG_MNFCTR_MDL_PK |
| TableName | MAG_MNFCTR_MDL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MAG_MNFCTR_MDL.MAG_MNFCTR_MDL_PK Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| MAG_MNFCTR_MDL.MAG_MNFCTR_MDL_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MAG_MNFCTR_MDL.MAG_MNFCTR_MDL_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MAG_MNFCTR_MDL.MAG_MNFCTR_MDL_PK Bound Attachments |
| Name | Current Value |
| MAG_MNFCTR_MDL.Ref86414 |
| TableName | MAG_MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref86414 ON MAG_MNFCTR_MDL(MNFCTR_ID, MDL_NBR) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MAG_MNFCTR_MDL.Ref86414 Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| MAG_MNFCTR_MDL.Ref86414 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MAG_MNFCTR_MDL.Ref86414 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MAG_MNFCTR_MDL.Ref86414 Bound Attachments |
| Name | Current Value |
| MNFCTR.MNFCTR_PK |
| TableName | MNFCTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MNFCTR.MNFCTR_PK Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MNFCTR.MNFCTR_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR.MNFCTR_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR.MNFCTR_PK Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.MNFCTR_MDL_PK |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MNFCTR_MDL.MNFCTR_MDL_PK Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| MNFCTR_MDL.MNFCTR_MDL_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.MNFCTR_MDL_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.MNFCTR_MDL_PK Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.EQUIP_MDL_TYPE_RF |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_MDL_TYPE_RF ON MNFCTR_MDL(EQUIP_CAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MNFCTR_MDL.EQUIP_MDL_TYPE_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| MNFCTR_MDL.EQUIP_MDL_TYPE_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.EQUIP_MDL_TYPE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.EQUIP_MDL_TYPE_RF Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.MNFCTR_RF |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX MNFCTR_RF ON MNFCTR_MDL(MNFCTR_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MNFCTR_MDL.MNFCTR_RF Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MNFCTR_MDL.MNFCTR_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.MNFCTR_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.MNFCTR_RF Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.MNFCTR_RF |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX MNFCTR_RF ON MNFCTR_MDL(MNFCTR_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MNFCTR_MDL.MNFCTR_RF Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MNFCTR_MDL.MNFCTR_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.MNFCTR_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.MNFCTR_RF Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.EQUIP_CAT_MDL_RF |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_CAT_MDL_RF ON MNFCTR_MDL(EQUIP_CAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MNFCTR_MDL.EQUIP_CAT_MDL_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| MNFCTR_MDL.EQUIP_CAT_MDL_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.EQUIP_CAT_MDL_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.EQUIP_CAT_MDL_RF Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.UOM_MNFCTR_MDL_RF |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX UOM_MNFCTR_MDL_RF ON MNFCTR_MDL(DIMENSIONS_UOM) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MNFCTR_MDL.UOM_MNFCTR_MDL_RF Index Columns |
| ColumnName | Sort Order |
| DIMENSIONS_UOM | Ascending |
| MNFCTR_MDL.UOM_MNFCTR_MDL_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.UOM_MNFCTR_MDL_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.UOM_MNFCTR_MDL_RF Bound Attachments |
| Name | Current Value |
| MNFCTR_MDL.MNFTR_MDL_SUBCAT_RF |
| TableName | MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX MNFTR_MDL_SUBCAT_RF ON MNFCTR_MDL(EQUIP_SUBCAT_ID, EQUIP_CAT_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MNFCTR_MDL.MNFTR_MDL_SUBCAT_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_SUBCAT_ID | Ascending |
| EQUIP_CAT_ID | Ascending |
| MNFCTR_MDL.MNFTR_MDL_SUBCAT_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MNFCTR_MDL.MNFTR_MDL_SUBCAT_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MNFCTR_MDL.MNFTR_MDL_SUBCAT_RF Bound Attachments |
| Name | Current Value |
| PWR_SPLY.PWR_SPLY_PK |
| TableName | PWR_SPLY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PWR_SPLY.PWR_SPLY_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| MOD_DTE | Ascending |
| PWR_SPLY.PWR_SPLY_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PWR_SPLY.PWR_SPLY_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PWR_SPLY.PWR_SPLY_PK Bound Attachments |
| Name | Current Value |
| PWR_SPLY.Ref9784 |
| TableName | PWR_SPLY |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref9784 ON PWR_SPLY(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| PWR_SPLY.Ref9784 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| PWR_SPLY.Ref9784 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PWR_SPLY.Ref9784 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PWR_SPLY.Ref9784 Bound Attachments |
| Name | Current Value |
| PWR_SPLY_CYCLE_ON.CYCLE_ON_PK_1 |
| TableName | PWR_SPLY_CYCLE_ON |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PWR_SPLY_CYCLE_ON.CYCLE_ON_PK_1 Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| CYCLE_ON_TIME | Ascending |
| PWR_SPLY_CYCLE_ON.CYCLE_ON_PK_1 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PWR_SPLY_CYCLE_ON.CYCLE_ON_PK_1 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PWR_SPLY_CYCLE_ON.CYCLE_ON_PK_1 Bound Attachments |
| Name | Current Value |
| PWR_SPLY_CYCLE_ON.PWR_SPLY_MNFCTR_MDL_CYCLE_RF |
| TableName | PWR_SPLY_CYCLE_ON |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PWR_SPLY_MNFCTR_MDL_CYCLE_RF ON PWR_SPLY_CYCLE_ON(MNFCTR_ID, MDL_NBR) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| PWR_SPLY_CYCLE_ON.PWR_SPLY_MNFCTR_MDL_CYCLE_RF Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| PWR_SPLY_CYCLE_ON.PWR_SPLY_MNFCTR_MDL_CYCLE_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PWR_SPLY_CYCLE_ON.PWR_SPLY_MNFCTR_MDL_CYCLE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PWR_SPLY_CYCLE_ON.PWR_SPLY_MNFCTR_MDL_CYCLE_RF Bound Attachments |
| Name | Current Value |
| PWR_SPLY_MNFCTR_MDL.PWR_SPLY_MNFCTR_MDL_PK |
| TableName | PWR_SPLY_MNFCTR_MDL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PWR_SPLY_MNFCTR_MDL.PWR_SPLY_MNFCTR_MDL_PK Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| PWR_SPLY_MNFCTR_MDL.PWR_SPLY_MNFCTR_MDL_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PWR_SPLY_MNFCTR_MDL.PWR_SPLY_MNFCTR_MDL_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PWR_SPLY_MNFCTR_MDL.PWR_SPLY_MNFCTR_MDL_PK Bound Attachments |
| Name | Current Value |
| PWR_SPLY_MNFCTR_MDL.Ref86430 |
| TableName | PWR_SPLY_MNFCTR_MDL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref86430 ON PWR_SPLY_MNFCTR_MDL(MNFCTR_ID, MDL_NBR) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| PWR_SPLY_MNFCTR_MDL.Ref86430 Index Columns |
| ColumnName | Sort Order |
| MNFCTR_ID | Ascending |
| MDL_NBR | Ascending |
| PWR_SPLY_MNFCTR_MDL.Ref86430 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PWR_SPLY_MNFCTR_MDL.Ref86430 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PWR_SPLY_MNFCTR_MDL.Ref86430 Bound Attachments |
| Name | Current Value |
| RCPT_ITEM.RECPT_ITEM_PK |
| TableName | RCPT_ITEM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RCPT_ITEM.RECPT_ITEM_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_RCPT_ID | Ascending |
| EQUIP_RCPT_VER | Ascending |
| RCPT_ITEM_ID | Ascending |
| RCPT_ITEM.RECPT_ITEM_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RCPT_ITEM.RECPT_ITEM_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RCPT_ITEM.RECPT_ITEM_PK Bound Attachments |
| Name | Current Value |
| RCPT_ITEM.EQUIP_RCPT_ITEM_RF |
| TableName | RCPT_ITEM |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EQUIP_RCPT_ITEM_RF ON RCPT_ITEM(EQUIP_RCPT_ID, EQUIP_RCPT_VER) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| RCPT_ITEM.EQUIP_RCPT_ITEM_RF Index Columns |
| ColumnName | Sort Order |
| EQUIP_RCPT_ID | Ascending |
| EQUIP_RCPT_VER | Ascending |
| RCPT_ITEM.EQUIP_RCPT_ITEM_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RCPT_ITEM.EQUIP_RCPT_ITEM_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RCPT_ITEM.EQUIP_RCPT_ITEM_RF Bound Attachments |
| Name | Current Value |
| RCPT_ITEM.RCPT_ITEM_BLDG_AREA_RF |
| TableName | RCPT_ITEM |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX RCPT_ITEM_BLDG_AREA_RF ON RCPT_ITEM(AREA_ID, BLDG_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| RCPT_ITEM.RCPT_ITEM_BLDG_AREA_RF Index Columns |
| ColumnName | Sort Order |
| AREA_ID | Ascending |
| BLDG_ID | Ascending |
| RCPT_ITEM.RCPT_ITEM_BLDG_AREA_RF 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RCPT_ITEM.RCPT_ITEM_BLDG_AREA_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RCPT_ITEM.RCPT_ITEM_BLDG_AREA_RF Bound Attachments |
| Name | Current Value |
| RCVD_BY.RECVD_BY_PK |
| TableName | RCVD_BY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RCVD_BY.RECVD_BY_PK Index Columns |
| ColumnName | Sort Order |
| RCVD_BY_BN | Ascending |
| RCVD_BY.RECVD_BY_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RCVD_BY.RECVD_BY_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RCVD_BY.RECVD_BY_PK Bound Attachments |
| Name | Current Value |
| RF_CAV.PK373 |
| TableName | RF_CAV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RF_CAV.PK373 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| RF_CAV.PK373 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RF_CAV.PK373 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RF_CAV.PK373 Bound Attachments |
| Name | Current Value |
| RF_CAV.Ref9659 |
| TableName | RF_CAV |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref9659 ON RF_CAV(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| RF_CAV.Ref9659 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| RF_CAV.Ref9659 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RF_CAV.Ref9659 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RF_CAV.Ref9659 Bound Attachments |
| Name | Current Value |
| RF_CAV_GAP_PARAM.PK374 |
| TableName | RF_CAV_GAP_PARAM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RF_CAV_GAP_PARAM.PK374 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| CELL_NBR | Ascending |
| SCENARIO_ID | Ascending |
| RF_CAV_GAP_PARAM.PK374 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RF_CAV_GAP_PARAM.PK374 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RF_CAV_GAP_PARAM.PK374 Bound Attachments |
| Name | Current Value |
| RF_CAV_GAP_PARAM.Ref373664 |
| TableName | RF_CAV_GAP_PARAM |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref373664 ON RF_CAV_GAP_PARAM(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| RF_CAV_GAP_PARAM.Ref373664 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| RF_CAV_GAP_PARAM.Ref373664 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RF_CAV_GAP_PARAM.Ref373664 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RF_CAV_GAP_PARAM.Ref373664 Bound Attachments |
| Name | Current Value |
| SC_CAV_PARAM.PK376 |
| TableName | SC_CAV_PARAM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SC_CAV_PARAM.PK376 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| SC_CAV_PARAM.PK376 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SC_CAV_PARAM.PK376 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SC_CAV_PARAM.PK376 Bound Attachments |
| Name | Current Value |
| SC_CAV_PARAM.Ref373669 |
| TableName | SC_CAV_PARAM |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref373669 ON SC_CAV_PARAM(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| SC_CAV_PARAM.Ref373669 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| SC_CAV_PARAM.Ref373669 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SC_CAV_PARAM.Ref373669 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SC_CAV_PARAM.Ref373669 Bound Attachments |
| Name | Current Value |
| UNIT_OF_MEASURE.UOM_PK |
| TableName | UNIT_OF_MEASURE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UNIT_OF_MEASURE.UOM_PK Index Columns |
| ColumnName | Sort Order |
| UOM | Ascending |
| UNIT_OF_MEASURE.UOM_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| UNIT_OF_MEASURE.UOM_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UNIT_OF_MEASURE.UOM_PK Bound Attachments |
| Name | Current Value |
| USER_INSTR.USER_INSTR_PK |
| TableName | USER_INSTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| USER_INSTR.USER_INSTR_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| USER_INSTR.USER_INSTR_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| USER_INSTR.USER_INSTR_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| USER_INSTR.USER_INSTR_PK Bound Attachments |
| Name | Current Value |
| USER_INSTR.Ref168311 |
| TableName | USER_INSTR |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref168311 ON USER_INSTR(USER_INSTR_TYPE_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| USER_INSTR.Ref168311 Index Columns |
| ColumnName | Sort Order |
| USER_INSTR_TYPE_ID | Ascending |
| USER_INSTR.Ref168311 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| USER_INSTR.Ref168311 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| USER_INSTR.Ref168311 Bound Attachments |
| Name | Current Value |
| USER_INSTR.Ref9329 |
| TableName | USER_INSTR |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX Ref9329 ON USER_INSTR(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EQUIP_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| USER_INSTR.Ref9329 Index Columns |
| ColumnName | Sort Order |
| EQUIP_ID | Ascending |
| USER_INSTR.Ref9329 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| USER_INSTR.Ref9329 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| USER_INSTR.Ref9329 Bound Attachments |
| Name | Current Value |
| USER_INSTR_CALIB.USER_INSTR_CALIB_PK |
| TableName | USER_INSTR_CALIB |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| USER_INSTR_CALIB.USER_INSTR_CALIB_PK Index Columns |
| ColumnName | Sort Order |
| STRT_DTE | Ascending |
| EQUIP_ID | Ascending |
| USER_INSTR_CALIB.USER_INSTR_CALIB_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| USER_INSTR_CALIB.USER_INSTR_CALIB_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| USER_INSTR_CALIB.USER_INSTR_CALIB_PK Bound Attachments |
| Name | Current Value |
| USER_INSTR_TYPE.USER_INSTR_TYPE_PK |
| TableName | USER_INSTR_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| USER_INSTR_TYPE.USER_INSTR_TYPE_PK Index Columns |
| ColumnName | Sort Order |
| USER_INSTR_TYPE_ID | Ascending |
| USER_INSTR_TYPE.USER_INSTR_TYPE_PK 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 | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| USER_INSTR_TYPE.USER_INSTR_TYPE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| USER_INSTR_TYPE.USER_INSTR_TYPE_PK Bound Attachments |
| Name | Current Value |