| ADC_DVC.PK_ADC_PK |
| TableName | ADC_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ADC_DVC.PK_ADC_PK Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| ADC_DVC.PK_ADC_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ADC_DVC.PK_ADC_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ADC_DVC.PK_ADC_PK Bound Attachments |
| Name | Current Value |
| ADC_DVC.Ref1932 |
| TableName | ADC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1932 ON EPICS.ADC_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ADC_DVC.Ref1932 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| ADC_DVC.Ref1932 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ADC_DVC.Ref1932 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ADC_DVC.Ref1932 Bound Attachments |
| Name | Current Value |
| ADC_DVC.FK_ADC_AFE_DVC |
| TableName | ADC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ADC_AFE_DVC ON EPICS.ADC_DVC(AFE_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ADC_DVC.FK_ADC_AFE_DVC Index Columns |
| ColumnName | Sort Order |
| AFE_DVC_ID | Ascending |
| ADC_DVC.FK_ADC_AFE_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ADC_DVC.FK_ADC_AFE_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ADC_DVC.FK_ADC_AFE_DVC Bound Attachments |
| Name | Current Value |
| ADC_DVC.FK_ADC_BLM_IOC_DVC |
| TableName | ADC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ADC_BLM_IOC_DVC ON EPICS.ADC_DVC(BLM_IOC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ADC_DVC.FK_ADC_BLM_IOC_DVC Index Columns |
| ColumnName | Sort Order |
| BLM_IOC_DVC_ID | Ascending |
| ADC_DVC.FK_ADC_BLM_IOC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ADC_DVC.FK_ADC_BLM_IOC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ADC_DVC.FK_ADC_BLM_IOC_DVC Bound Attachments |
| Name | Current Value |
| AFE_DVC.PK_AFE_DVC |
| TableName | AFE_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| AFE_DVC.PK_AFE_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| AFE_DVC.PK_AFE_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| AFE_DVC.PK_AFE_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| AFE_DVC.PK_AFE_DVC Bound Attachments |
| Name | Current Value |
| AFE_DVC.Ref1933 |
| TableName | AFE_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1933 ON EPICS.AFE_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| AFE_DVC.Ref1933 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| AFE_DVC.Ref1933 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| AFE_DVC.Ref1933 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| AFE_DVC.Ref1933 Bound Attachments |
| Name | Current Value |
| AFE_DVC.FK_AFE_BLM_IOC_DVC |
| TableName | AFE_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_AFE_BLM_IOC_DVC ON EPICS.AFE_DVC(BLM_IOC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| AFE_DVC.FK_AFE_BLM_IOC_DVC Index Columns |
| ColumnName | Sort Order |
| BLM_IOC_DVC_ID | Ascending |
| AFE_DVC.FK_AFE_BLM_IOC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| AFE_DVC.FK_AFE_BLM_IOC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| AFE_DVC.FK_AFE_BLM_IOC_DVC Bound Attachments |
| Name | Current Value |
| BLM_DVC.PK_BLM_DVC |
| TableName | BLM_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BLM_DVC.PK_BLM_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| BLM_DVC.PK_BLM_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.PK_BLM_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.PK_BLM_DVC Bound Attachments |
| Name | Current Value |
| BLM_DVC.Ref1910 |
| TableName | BLM_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1910 ON EPICS.BLM_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLM_DVC.Ref1910 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| BLM_DVC.Ref1910 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.Ref1910 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.Ref1910 Bound Attachments |
| Name | Current Value |
| BLM_DVC.FK_BLM_SSA_DVC |
| TableName | BLM_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_BLM_SSA_DVC ON EPICS.BLM_DVC(SSA_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLM_DVC.FK_BLM_SSA_DVC Index Columns |
| ColumnName | Sort Order |
| SSA_DVC_ID | Ascending |
| BLM_DVC.FK_BLM_SSA_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.FK_BLM_SSA_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.FK_BLM_SSA_DVC Bound Attachments |
| Name | Current Value |
| BLM_DVC.FK_BLM_HVPS_DVC |
| TableName | BLM_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_BLM_HVPS_DVC ON EPICS.BLM_DVC(HVPS_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLM_DVC.FK_BLM_HVPS_DVC Index Columns |
| ColumnName | Sort Order |
| HVPS_DVC_ID | Ascending |
| BLM_DVC.FK_BLM_HVPS_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.FK_BLM_HVPS_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.FK_BLM_HVPS_DVC Bound Attachments |
| Name | Current Value |
| BLM_DVC.FK_BLM_MPS_INTFC_DVC |
| TableName | BLM_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_BLM_MPS_INTFC_DVC ON EPICS.BLM_DVC(MPS_INTFC_DVC) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLM_DVC.FK_BLM_MPS_INTFC_DVC Index Columns |
| ColumnName | Sort Order |
| MPS_INTFC_DVC | Ascending |
| BLM_DVC.FK_BLM_MPS_INTFC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.FK_BLM_MPS_INTFC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.FK_BLM_MPS_INTFC_DVC Bound Attachments |
| Name | Current Value |
| BLM_DVC.FK_BLM_ADC_DVC |
| TableName | BLM_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_BLM_ADC_DVC ON EPICS.BLM_DVC(ADC_SLOW_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLM_DVC.FK_BLM_ADC_DVC Index Columns |
| ColumnName | Sort Order |
| ADC_SLOW_DVC_ID | Ascending |
| BLM_DVC.FK_BLM_ADC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.FK_BLM_ADC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.FK_BLM_ADC_DVC Bound Attachments |
| Name | Current Value |
| BLM_DVC.Ref1963 |
| TableName | BLM_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1963 ON EPICS.BLM_DVC(ADC_FAST_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| BLM_DVC.Ref1963 Index Columns |
| ColumnName | Sort Order |
| ADC_FAST_DVC_ID | Ascending |
| BLM_DVC.Ref1963 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| BLM_DVC.Ref1963 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_DVC.Ref1963 Bound Attachments |
| Name | Current Value |
| DAC_DVC.PK_DAC_DVC |
| TableName | DAC_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DAC_DVC.PK_DAC_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| DAC_DVC.PK_DAC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DAC_DVC.PK_DAC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DAC_DVC.PK_DAC_DVC Bound Attachments |
| Name | Current Value |
| DAC_DVC.Ref1934 |
| TableName | DAC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1934 ON EPICS.DAC_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DAC_DVC.Ref1934 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| DAC_DVC.Ref1934 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DAC_DVC.Ref1934 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DAC_DVC.Ref1934 Bound Attachments |
| Name | Current Value |
| DAC_DVC.FK_DAC_AFE_DVC |
| TableName | DAC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_DAC_AFE_DVC ON EPICS.DAC_DVC(AFE_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DAC_DVC.FK_DAC_AFE_DVC Index Columns |
| ColumnName | Sort Order |
| AFE_DVC_ID | Ascending |
| DAC_DVC.FK_DAC_AFE_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DAC_DVC.FK_DAC_AFE_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DAC_DVC.FK_DAC_AFE_DVC Bound Attachments |
| Name | Current Value |
| DAC_DVC.FK_DAC_IP_CARR_DVC |
| TableName | DAC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_DAC_IP_CARR_DVC ON EPICS.DAC_DVC(IP_CARR_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DAC_DVC.FK_DAC_IP_CARR_DVC Index Columns |
| ColumnName | Sort Order |
| IP_CARR_DVC_ID | Ascending |
| DAC_DVC.FK_DAC_IP_CARR_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DAC_DVC.FK_DAC_IP_CARR_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DAC_DVC.FK_DAC_IP_CARR_DVC Bound Attachments |
| Name | Current Value |
| DIGIO_DVC.PK_DIGIO_DVC |
| TableName | DIGIO_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DIGIO_DVC.PK_DIGIO_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| DIGIO_DVC.PK_DIGIO_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DIGIO_DVC.PK_DIGIO_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIGIO_DVC.PK_DIGIO_DVC Bound Attachments |
| Name | Current Value |
| DIGIO_DVC.Ref1931 |
| TableName | DIGIO_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1931 ON EPICS.DIGIO_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DIGIO_DVC.Ref1931 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| DIGIO_DVC.Ref1931 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DIGIO_DVC.Ref1931 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIGIO_DVC.Ref1931 Bound Attachments |
| Name | Current Value |
| DIGIO_DVC.FK_DIGIO_AFE_DVC |
| TableName | DIGIO_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_DIGIO_AFE_DVC ON EPICS.DIGIO_DVC(AFE_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DIGIO_DVC.FK_DIGIO_AFE_DVC Index Columns |
| ColumnName | Sort Order |
| AFE_DVC_ID | Ascending |
| DIGIO_DVC.FK_DIGIO_AFE_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DIGIO_DVC.FK_DIGIO_AFE_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIGIO_DVC.FK_DIGIO_AFE_DVC Bound Attachments |
| Name | Current Value |
| DIGIO_DVC.FK_DIGIO_BLM_DVC |
| TableName | DIGIO_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_DIGIO_BLM_DVC ON EPICS.DIGIO_DVC(BLM_IOC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DIGIO_DVC.FK_DIGIO_BLM_DVC Index Columns |
| ColumnName | Sort Order |
| BLM_IOC_DVC_ID | Ascending |
| DIGIO_DVC.FK_DIGIO_BLM_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DIGIO_DVC.FK_DIGIO_BLM_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIGIO_DVC.FK_DIGIO_BLM_DVC Bound Attachments |
| Name | Current Value |
| DVC.DEVICE_PK |
| TableName | DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DVC.DEVICE_PK Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| DVC.DEVICE_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DVC.DEVICE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DVC.DEVICE_PK Bound Attachments |
| Name | Current Value |
| DVC.DVC_ID_ALIAS_IDX |
| TableName | DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE UNIQUE INDEX EPICS.DVC_ID_ALIAS_IDX ON EPICS.DVC(DVC_ID_ALIAS) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DVC.DVC_ID_ALIAS_IDX Index Columns |
| ColumnName | Sort Order |
| DVC_ID_ALIAS | Ascending |
| DVC.DVC_ID_ALIAS_IDX Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DVC.DVC_ID_ALIAS_IDX Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DVC.DVC_ID_ALIAS_IDX Bound Attachments |
| Name | Current Value |
| DVC.PARENT_DVC_ID_DVC_RF |
| TableName | DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.PARENT_DVC_ID_DVC_RF ON EPICS.DVC(PARENT_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| DVC.PARENT_DVC_ID_DVC_RF Index Columns |
| ColumnName | Sort Order |
| PARENT_DVC_ID | Ascending |
| DVC.PARENT_DVC_ID_DVC_RF Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| DVC.PARENT_DVC_ID_DVC_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DVC.PARENT_DVC_ID_DVC_RF Bound Attachments |
| Name | Current Value |
| HVPS_DVC.PK_HVPS_DVC |
| TableName | HVPS_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| HVPS_DVC.PK_HVPS_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| HVPS_DVC.PK_HVPS_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| HVPS_DVC.PK_HVPS_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| HVPS_DVC.PK_HVPS_DVC Bound Attachments |
| Name | Current Value |
| HVPS_DVC.Ref1928 |
| TableName | HVPS_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1928 ON EPICS.HVPS_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| HVPS_DVC.Ref1928 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| HVPS_DVC.Ref1928 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| HVPS_DVC.Ref1928 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| HVPS_DVC.Ref1928 Bound Attachments |
| Name | Current Value |
| IP_CARR_DVC.PK_IP_CARR_DVC |
| TableName | IP_CARR_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| IP_CARR_DVC.PK_IP_CARR_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| IP_CARR_DVC.PK_IP_CARR_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| IP_CARR_DVC.PK_IP_CARR_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| IP_CARR_DVC.PK_IP_CARR_DVC Bound Attachments |
| Name | Current Value |
| IP_CARR_DVC.Ref1958 |
| TableName | IP_CARR_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1958 ON EPICS.IP_CARR_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| IP_CARR_DVC.Ref1958 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| IP_CARR_DVC.Ref1958 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| IP_CARR_DVC.Ref1958 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| IP_CARR_DVC.Ref1958 Bound Attachments |
| Name | Current Value |
| MACHINE_MODE.MACHINE_MODE_PK |
| TableName | MACHINE_MODE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MACHINE_MODE.MACHINE_MODE_PK Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| APPR_DTE | Ascending |
| CHANNEL_NBR | Ascending |
| MACHINE_MODE.MACHINE_MODE_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MACHINE_MODE.MACHINE_MODE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MACHINE_MODE.MACHINE_MODE_PK Bound Attachments |
| Name | Current Value |
| MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF |
| TableName | MACHINE_MODE |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.MPS_SGNL_PARAM_MACH_MODE_RF ON EPICS.MACHINE_MODE(DVC_ID, APPR_DTE) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| APPR_DTE | Ascending |
| MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MACHINE_MODE.MPS_SGNL_PARAM_MACH_MODE_RF Bound Attachments |
| Name | Current Value |
| MACHINE_MODE.MACHINE_MODE_DVC_FK |
| TableName | MACHINE_MODE |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.MACHINE_MODE_DVC_FK ON EPICS.MACHINE_MODE(MPS_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MACHINE_MODE.MACHINE_MODE_DVC_FK Index Columns |
| ColumnName | Sort Order |
| MPS_DVC_ID | Ascending |
| MACHINE_MODE.MACHINE_MODE_DVC_FK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MACHINE_MODE.MACHINE_MODE_DVC_FK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MACHINE_MODE.MACHINE_MODE_DVC_FK Bound Attachments |
| Name | Current Value |
| MPS_INTFC_DVC.PK_MPS_INTFC_DVC |
| TableName | MPS_INTFC_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MPS_INTFC_DVC.PK_MPS_INTFC_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| MPS_INTFC_DVC.PK_MPS_INTFC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_INTFC_DVC.PK_MPS_INTFC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_INTFC_DVC.PK_MPS_INTFC_DVC Bound Attachments |
| Name | Current Value |
| MPS_INTFC_DVC.Ref1929 |
| TableName | MPS_INTFC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1929 ON EPICS.MPS_INTFC_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MPS_INTFC_DVC.Ref1929 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| MPS_INTFC_DVC.Ref1929 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_INTFC_DVC.Ref1929 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_INTFC_DVC.Ref1929 Bound Attachments |
| Name | Current Value |
| MPS_INTFC_DVC.FK_MPS_INTFC_MIOC_DVC |
| TableName | MPS_INTFC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_MPS_INTFC_MIOC_DVC ON EPICS.MPS_INTFC_DVC(MIOC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MPS_INTFC_DVC.FK_MPS_INTFC_MIOC_DVC Index Columns |
| ColumnName | Sort Order |
| MIOC_DVC_ID | Ascending |
| MPS_INTFC_DVC.FK_MPS_INTFC_MIOC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_INTFC_DVC.FK_MPS_INTFC_MIOC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_INTFC_DVC.FK_MPS_INTFC_MIOC_DVC Bound Attachments |
| Name | Current Value |
| MPS_INTFC_DVC.FK_MPS_INTFC_AFE_DVC |
| TableName | MPS_INTFC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_MPS_INTFC_AFE_DVC ON EPICS.MPS_INTFC_DVC(AFE_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MPS_INTFC_DVC.FK_MPS_INTFC_AFE_DVC Index Columns |
| ColumnName | Sort Order |
| AFE_DVC_ID | Ascending |
| MPS_INTFC_DVC.FK_MPS_INTFC_AFE_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_INTFC_DVC.FK_MPS_INTFC_AFE_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_INTFC_DVC.FK_MPS_INTFC_AFE_DVC Bound Attachments |
| Name | Current Value |
| MPS_INTFC_DVC.FK_MPS_INFRC_IOC_DVC |
| TableName | MPS_INTFC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_MPS_INFRC_IOC_DVC ON EPICS.MPS_INTFC_DVC(BLM_IOC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MPS_INTFC_DVC.FK_MPS_INFRC_IOC_DVC Index Columns |
| ColumnName | Sort Order |
| BLM_IOC_DVC_ID | Ascending |
| MPS_INTFC_DVC.FK_MPS_INFRC_IOC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_INTFC_DVC.FK_MPS_INFRC_IOC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_INTFC_DVC.FK_MPS_INFRC_IOC_DVC Bound Attachments |
| Name | Current Value |
| MPS_INTFC_DVC.Ref1964 |
| TableName | MPS_INTFC_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1964 ON EPICS.MPS_INTFC_DVC(IP_CARR_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MPS_INTFC_DVC.Ref1964 Index Columns |
| ColumnName | Sort Order |
| IP_CARR_DVC_ID | Ascending |
| MPS_INTFC_DVC.Ref1964 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_INTFC_DVC.Ref1964 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_INTFC_DVC.Ref1964 Bound Attachments |
| Name | Current Value |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK |
| TableName | MPS_SGNL_PARAM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| APPR_DTE | Ascending |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Bound Attachments |
| Name | Current Value |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF |
| TableName | MPS_SGNL_PARAM |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.MPS_SGNL_PARAM_DVC_RF ON EPICS.MPS_SGNL_PARAM(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MPS_SGNL_PARAM.MPS_SGNL_PARAM_DVC_RF Bound Attachments |
| Name | Current Value |
| ND_DVC.PK_ND_DVC |
| TableName | ND_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ND_DVC.PK_ND_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| ND_DVC.PK_ND_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.PK_ND_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.PK_ND_DVC Bound Attachments |
| Name | Current Value |
| ND_DVC.Ref1926 |
| TableName | ND_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1926 ON EPICS.ND_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ND_DVC.Ref1926 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| ND_DVC.Ref1926 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.Ref1926 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.Ref1926 Bound Attachments |
| Name | Current Value |
| ND_DVC.FK_ND_SSA_DVC |
| TableName | ND_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ND_SSA_DVC ON EPICS.ND_DVC(SSA_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ND_DVC.FK_ND_SSA_DVC Index Columns |
| ColumnName | Sort Order |
| SSA_DVC_ID | Ascending |
| ND_DVC.FK_ND_SSA_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.FK_ND_SSA_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.FK_ND_SSA_DVC Bound Attachments |
| Name | Current Value |
| ND_DVC.FK_ND_HVPD_DVC |
| TableName | ND_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ND_HVPD_DVC ON EPICS.ND_DVC(HVPS_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ND_DVC.FK_ND_HVPD_DVC Index Columns |
| ColumnName | Sort Order |
| HVPS_DVC_ID | Ascending |
| ND_DVC.FK_ND_HVPD_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.FK_ND_HVPD_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.FK_ND_HVPD_DVC Bound Attachments |
| Name | Current Value |
| ND_DVC.FK_ND_MPS_INTFC_DVC |
| TableName | ND_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ND_MPS_INTFC_DVC ON EPICS.ND_DVC(MPS_INTFC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ND_DVC.FK_ND_MPS_INTFC_DVC Index Columns |
| ColumnName | Sort Order |
| MPS_INTFC_DVC_ID | Ascending |
| ND_DVC.FK_ND_MPS_INTFC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.FK_ND_MPS_INTFC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.FK_ND_MPS_INTFC_DVC Bound Attachments |
| Name | Current Value |
| ND_DVC.FK_ND_ADC_SLOW_DVC |
| TableName | ND_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ND_ADC_SLOW_DVC ON EPICS.ND_DVC(ADC_SLOW_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ND_DVC.FK_ND_ADC_SLOW_DVC Index Columns |
| ColumnName | Sort Order |
| ADC_SLOW_DVC_ID | Ascending |
| ND_DVC.FK_ND_ADC_SLOW_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.FK_ND_ADC_SLOW_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.FK_ND_ADC_SLOW_DVC Bound Attachments |
| Name | Current Value |
| ND_DVC.FK_ND_ADC_FAST_DVC |
| TableName | ND_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_ND_ADC_FAST_DVC ON EPICS.ND_DVC(ADC_FAST_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ND_DVC.FK_ND_ADC_FAST_DVC Index Columns |
| ColumnName | Sort Order |
| ADC_FAST_DVC_ID | Ascending |
| ND_DVC.FK_ND_ADC_FAST_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| ND_DVC.FK_ND_ADC_FAST_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ND_DVC.FK_ND_ADC_FAST_DVC Bound Attachments |
| Name | Current Value |
| SSA_DVC.PK_SSA_DVC |
| TableName | SSA_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SSA_DVC.PK_SSA_DVC Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| SSA_DVC.PK_SSA_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| SSA_DVC.PK_SSA_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SSA_DVC.PK_SSA_DVC Bound Attachments |
| Name | Current Value |
| SSA_DVC.Ref1930 |
| TableName | SSA_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.Ref1930 ON EPICS.SSA_DVC(DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| SSA_DVC.Ref1930 Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| SSA_DVC.Ref1930 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| SSA_DVC.Ref1930 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SSA_DVC.Ref1930 Bound Attachments |
| Name | Current Value |
| SSA_DVC.FK_SSA_AFE_DVC |
| TableName | SSA_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_SSA_AFE_DVC ON EPICS.SSA_DVC(AFE_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| SSA_DVC.FK_SSA_AFE_DVC Index Columns |
| ColumnName | Sort Order |
| AFE_DVC_ID | Ascending |
| SSA_DVC.FK_SSA_AFE_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| SSA_DVC.FK_SSA_AFE_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SSA_DVC.FK_SSA_AFE_DVC Bound Attachments |
| Name | Current Value |
| SSA_DVC.FK_SSA_MPS_INTFC_DVC |
| TableName | SSA_DVC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX EPICS.FK_SSA_MPS_INTFC_DVC ON EPICS.SSA_DVC(MPS_INTFC_DVC_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| SSA_DVC.FK_SSA_MPS_INTFC_DVC Index Columns |
| ColumnName | Sort Order |
| MPS_INTFC_DVC_ID | Ascending |
| SSA_DVC.FK_SSA_MPS_INTFC_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| 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 |
| SSA_DVC.FK_SSA_MPS_INTFC_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SSA_DVC.FK_SSA_MPS_INTFC_DVC Bound Attachments |
| Name | Current Value |