New Vista Table Indexes
The following is a list of Vista table indexes added for the 2025.6 release.
| Table Name | Index Name | Column Name | Primary | Unique |
|---|---|---|---|---|
| bAPDB | PK_bAPDB_auto_generated | AuditID | Y | Y |
| bAPHB | PK_bAPHB_auto_generated | AuditID | Y | Y |
| bAPPB | PK_bAPPB_auto_generated | AuditID | Y | Y |
| bAPTB | PK_bAPTB_auto_generated | AuditID | Y | Y |
| udtCustomLinks_TC1 | pk_udtCustomLinks_TC1_CustomID | CustomID | Y | Y |
| udtExecDashCacheAP_TC1 | pk_udtExecDashCacheAP_TC1_KeyID | KeyID | Y | Y |
| udtExecDashCacheAPAll_TC1 | pk_udtExecDashCacheAPAll_TC1_KeyID | KeyID | Y | Y |
| udtExecDashCacheAR_TC1 | pk_udtExecDashCacheAR_TC1_KeyID | KeyID | Y | Y |
| udtExecDashCacheJCWIP_TC1 | pk_udtExecDashCacheJCWIP_TC1_TC1_KeyID | KeyID | Y | Y |
| udtExecDashCacheJCWIPxtd_TC1 | pk_udtExecDashCacheJCWIPxtd_TC1_KeyID | KeyID | Y | Y |
| udtExecDashCacheLastUpdate_TC1 | IX_udtExecDashCacheLastUpdateRevenue_TC1 | Job | N | Y |
| udtExecDashCacheLastUpdate_TC1 | idx_udtExecDashCacheLastUpdate_TC1_KeyID | KeyID | N | Y |
| udtExecDashCacheLastUpdateCost_TC1 | pk_udtExecDashCacheLastUpdateCost_TC1_KeyID | KeyID | Y | Y |
| udtExecDashCacheProcessHistory_TC1 | pk_udtExecDashCacheProcessHistory_TC1_CacheID | CacheID | Y | Y |
| udtExecDashCacheProcessLog_TC1 | pk_udtExecDashCacheProcessLog_TC1_LogID | LogID | Y | Y |
| udtSimpleLog_TC1 | pk_udtSimpleLog_TC1_ErrorID | ErrorID | Y | Y |
