CYCLE_ON.MAG_CYCLE_ON_RF |
TableName | CYCLE_ON |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MAG_CYCLE_ON_RF ON CYCLE_ON(EQUIP_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE MAGNET_INDEX_TS      LOGGING      STORAGE(INITIAL 10K              NEXT 10K              MINEXTENTS 1              MAXEXTENTS 121              PCTINCREASE 50              ) ; |
CYCLE_ON.MAG_CYCLE_ON_RF Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
CYCLE_ON.MAG_CYCLE_ON_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
CYCLE_ON.MAG_CYCLE_ON_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CYCLE_ON.MAG_CYCLE_ON_RF Bound Attachments |
Name | Current Value |
EXCITAION_CURVE.MAG_EXCITAION_CURVE_RF |
TableName | EXCITAION_CURVE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MAG_EXCITAION_CURVE_RF ON EXCITAION_CURVE(EQUIP_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE MAGNET_INDEX_TS      LOGGING      STORAGE(INITIAL 10K              NEXT 10K              MINEXTENTS 1              MAXEXTENTS 121              PCTINCREASE 50              ) ; |
EXCITAION_CURVE.MAG_EXCITAION_CURVE_RF Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
EXCITAION_CURVE.MAG_EXCITAION_CURVE_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
EXCITAION_CURVE.MAG_EXCITAION_CURVE_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXCITAION_CURVE.MAG_EXCITAION_CURVE_RF Bound Attachments |
Name | Current Value |
MAG.MAG_PK |
TableName | MAG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MAG.MAG_PK Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
MAG.MAG_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MAG.MAG_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAG.MAG_PK Bound Attachments |
Name | Current Value |
MAG_CHK.MAG_MAG_CHK_RF |
TableName | MAG_CHK |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MAG_MAG_CHK_RF ON MAG_CHK(EQUIP_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE MAGNET_INDEX_TS      LOGGING      STORAGE(INITIAL 10K              NEXT 10K              MINEXTENTS 1              MAXEXTENTS 121              PCTINCREASE 50              ) ; |
MAG_CHK.MAG_MAG_CHK_RF Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
MAG_CHK.MAG_MAG_CHK_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MAG_CHK.MAG_MAG_CHK_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAG_CHK.MAG_MAG_CHK_RF Bound Attachments |
Name | Current Value |
MAG_SPLINE.MAG_SPLINE_PK |
TableName | MAG_SPLINE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MAG_SPLINE.MAG_SPLINE_PK Index Columns |
ColumnName | Sort Order |
FLD_CUR_FUNC_IND | Ascending |
EQUIP_ID | Ascending |
MAG_SPLINE.MAG_SPLINE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MAG_SPLINE.MAG_SPLINE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAG_SPLINE.MAG_SPLINE_PK Bound Attachments |
Name | Current Value |
MAG_SPLINE.MAG_MAG_SPLINE_RF |
TableName | MAG_SPLINE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MAG_MAG_SPLINE_RF ON MAG_SPLINE(EQUIP_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE MAGNET_INDEX_TS      LOGGING      STORAGE(INITIAL 10K              NEXT 10K              MINEXTENTS 1              MAXEXTENTS 121              PCTINCREASE 50              ) ; |
MAG_SPLINE.MAG_MAG_SPLINE_RF Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
MAG_SPLINE.MAG_MAG_SPLINE_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MAG_SPLINE.MAG_MAG_SPLINE_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAG_SPLINE.MAG_MAG_SPLINE_RF Bound Attachments |
Name | Current Value |
MULTIPOLES.MULTIPOLES_PK |
TableName | MULTIPOLES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MULTIPOLES.MULTIPOLES_PK Index Columns |
ColumnName | Sort Order |
TEST_DATE | Ascending |
EQUIP_ID | Ascending |
MULTIPOLES.MULTIPOLES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MULTIPOLES.MULTIPOLES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MULTIPOLES.MULTIPOLES_PK Bound Attachments |
Name | Current Value |
MULTIPOLES.MAG_MULTIPOLES_RF |
TableName | MULTIPOLES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MAG_MULTIPOLES_RF ON MULTIPOLES(EQUIP_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE MAGNET_INDEX_TS      LOGGING      STORAGE(INITIAL 10K              NEXT 10K              MINEXTENTS 1              MAXEXTENTS 121              PCTINCREASE 50              ) ; |
MULTIPOLES.MAG_MULTIPOLES_RF Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
MULTIPOLES.MAG_MULTIPOLES_RF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MULTIPOLES.MAG_MULTIPOLES_RF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MULTIPOLES.MAG_MULTIPOLES_RF Bound Attachments |
Name | Current Value |