MACH_SNAPSHOT.MACH_SNAPSHOT_PK |
TableName | MACH_SNAPSHOT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT.MACH_SNAPSHOT_PK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_ID | Ascending |
MACH_SNAPSHOT.MACH_SNAPSHOT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT.MACH_SNAPSHOT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT.MACH_SNAPSHOT_PK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_FK |
TableName | MACH_SNAPSHOT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MACH_SNAPSHOT_TYPE_FK ON MACH_SNAPSHOT(SNAPSHOT_TYPE_NM)      PCTFREE 0      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_FK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_TYPE_NM | Ascending |
MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_FK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_FK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_FK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK |
TableName | MACH_SNAPSHOT_PER |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_PER | Ascending |
MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK |
TableName | MACH_SNAPSHOT_RETENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_RETENT | Ascending |
MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK |
TableName | MACH_SNAPSHOT_SGNL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_ID | Ascending |
SGNL_ID | Ascending |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_MACH_FK |
TableName | MACH_SNAPSHOT_SGNL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MACH_SNAPSHOT_SGNL_MACH_FK ON MACH_SNAPSHOT_SGNL(SNAPSHOT_ID)      PCTFREE 0      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_MACH_FK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_ID | Ascending |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_MACH_FK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_MACH_FK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_MACH_FK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET |
TableName | MACH_SNAPSHOT_SGNL_PERM_RET |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Index Columns |
ColumnName | Sort Order |
SNAPSHOT_ID | Ascending |
SGNL_ID | Ascending |
MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_SVC.PK_MACH_SNAP_SVC |
TableName | MACH_SNAPSHOT_SVC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_SVC.PK_MACH_SNAP_SVC Index Columns |
ColumnName | Sort Order |
SVC_ID | Ascending |
MACH_SNAPSHOT_SVC.PK_MACH_SNAP_SVC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_SVC.PK_MACH_SNAP_SVC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_SVC.PK_MACH_SNAP_SVC Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK |
TableName | MACH_SNAPSHOT_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_TYPE_NM | Ascending |
MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_TYPE.Ref6151114 |
TableName | MACH_SNAPSHOT_TYPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EPICS.Ref6151114 ON EPICS.MACH_SNAPSHOT_TYPE(SVC_ID)      PCTFREE 0      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
MACH_SNAPSHOT_TYPE.Ref6151114 Index Columns |
ColumnName | Sort Order |
SVC_ID | Ascending |
MACH_SNAPSHOT_TYPE.Ref6151114 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_TYPE.Ref6151114 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_TYPE.Ref6151114 Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK |
TableName | MACH_SNAPSHOT_TYPE_SGNL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_TYPE_NM | Ascending |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_NM_FK |
TableName | MACH_SNAPSHOT_TYPE_SGNL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX MACH_SNAPSHOT_TYPE_SGNL_NM_FK ON MACH_SNAPSHOT_TYPE_SGNL(SNAPSHOT_TYPE_NM)      PCTFREE 0      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_NM_FK Index Columns |
ColumnName | Sort Order |
SNAPSHOT_TYPE_NM | Ascending |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_NM_FK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_NM_FK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_NM_FK Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_TYPE_SGNL.Ref102907 |
TableName | MACH_SNAPSHOT_TYPE_SGNL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX Ref102907 ON MACH_SNAPSHOT_TYPE_SGNL(SGNL_ID)      PCTFREE 0      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
MACH_SNAPSHOT_TYPE_SGNL.Ref102907 Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
MACH_SNAPSHOT_TYPE_SGNL.Ref102907 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
MACH_SNAPSHOT_TYPE_SGNL.Ref102907 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_TYPE_SGNL.Ref102907 Bound Attachments |
Name | Current Value |
SGNL_REC.SGNL_REC_PK |
TableName | SGNL_REC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SGNL_REC.SGNL_REC_PK Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
SGNL_REC.SGNL_REC_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL_REC.SGNL_REC_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.SGNL_REC_PK Bound Attachments |
Name | Current Value |
SGNL_REC.SGNL_ID_ALIAS_IDX |
TableName | SGNL_REC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SGNL_ID_ALIAS_IDX ON SGNL_REC(SGNL_ID_ALIAS)      PCTFREE 0      TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
SGNL_REC.SGNL_ID_ALIAS_IDX Index Columns |
ColumnName | Sort Order |
SGNL_ID_ALIAS | Ascending |
SGNL_REC.SGNL_ID_ALIAS_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_INDEX_TS |
PctFree | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SGNL_REC.SGNL_ID_ALIAS_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SGNL_REC.SGNL_ID_ALIAS_IDX Bound Attachments |
Name | Current Value |