The following is a list of table indexes added for the Vista 2023 R2 release.
| Table Name | Index Name | Column Name | Primary | Unique |
|---|---|---|---|---|
| bEMSIOrphans | PK_bEMSI_Orphans | ArchiveID | Y | Y |
| vDDCBShared_Data | PK_vDDCBShared_Data | ComboType | Y | Y |
| vDDCIShared_Data | PK_vDDCIShared_Data | ComboType | Y | Y |
| PK_vDDCIShared_Data | Seq | Y | Y | |
| vDDDTShared_Data | PK_vDDDT_SharedData | Datatype | Y | Y |
| vDDFHShared_Data | PK_vDDFHShared_Data | Form | Y | Y |
| vDDFIShared_Data | PK_vDDFI_SharedData | Form | Y | Y |
| PK_vDDFI_SharedData | Seq | Y | Y | |
| vDDFLShared_Data | PK_vDDFL_SharedData | Form | Y | Y |
| PK_vDDFL_SharedData | Lookup | Y | Y | |
| PK_vDDFL_SharedData | Seq | Y | Y | |
| vDDFTShared_Data | PK_vDDFT_SharedData | Form | Y | Y |
| PK_vDDFT_SharedData | Tab | Y | Y | |
| vDDLDShared_Data | PK_vDDLD_SharedData | Lookup | Y | Y |
| PK_vDDLD_SharedData | Seq | Y | Y | |
| vDDLHShared_Data | PK_vDDLH_SharedData | Lookup | Y | Y |
| vDDMFShared_Data | PK_vDDMF_SharedData | Form | Y | Y |
| PK_vDDMF_SharedData | Mod | Y | Y | |
| vDDSLShared_Data | PK_vDDSLShared_Data | Datatype | Y | Y |
| PK_vDDSLShared_Data | InstanceColumn | Y | Y | |
| PK_vDDSLShared_Data | TableName | Y | Y | |
| vDMAttachmentTypesShared_Data | PK_vDMAttachmentTypesShared_Data | AttachmentTypeID | Y | Y |
| vPRLedgerUpdateControl | PK_vPRLedgerUpdateControl_KeyHash | KeyHash | N | Y |
| vRPFDShared_Data | PK_vRPFDShared_Data | Form | Y | Y |
| PK_vRPFDShared_Data | ParameterName | Y | Y | |
| PK_vRPFDShared_Data | ReportID | Y | Y | |
| vRPFRShared_Data | PK_vRPFR_SharedData | Form | Y | Y |
| PK_vRPFR_SharedData | ReportID | Y | Y | |
| vRPPLShared_Data | PK_vRPPLShared_Data | Lookup | Y | Y |
| PK_vRPPLShared_Data | ParameterName | Y | Y | |
| PK_vRPPLShared_Data | ReportID | Y | Y | |
| vRPRMShared_Data | PK_vRPRM_SharedData | Mod | Y | Y |
| PK_vRPRM_SharedData | ReportID | Y | Y | |
| vRPRPShared_Data | PK_vRPRP_SharedData | ParameterName | Y | Y |
| PK_vRPRP_SharedData | ReportID | Y | Y | |
| vRPRTShared_Data | PK_vRPRT_SharedData | ReportID | Y | Y |
| vRPTYShared_Data | PK_vRPTYShared_Data | ReportType | Y | Y |
| vSMAgreementServiceWorkSchedule | IX_vSMAgreementServiceWorkSchedule | ServiceItem | N | Y |
| vSMInvoiceDetailOrphans | PK_vSMInvoiceDetailOrphans_ArchiveID | ArchiveID | Y | Y |
| vSMInvoiceLineOrphans | PK_vSMInvoiceLineOrphans_ArchiveID | ArchiveID | Y | Y |
| vSMWorkCompletedDetailOrphans | PK_vSMWorkCompletedDetailOrphans_Archive | ArchiveID | Y | Y |
| vSMWorkCompletedOrphans | PK_vSMWorkCompletedOrphans_ArchiveID | ArchiveID | Y | Y |
| vVPCanvasSettingsHistory | PK_VPLog_vVPCanvasSettingsHistory | Seq | Y | Y |
| vVPPartSettingsHistory | PK_VPLog_vVPPartSettingsHistory | Seq | Y | Y |