DDDAudit question regarding index-1
We are facing index inconsistency issue on few tables.
Example: table PO_POA_HDR_HIST has 3 index count on psrecdefn table, 3 indexid in pskeydefn table, 3 entries in psindesxdefn table.
when i rebuild the index(app designer) for table PO_POA_HDR_HIST. its drop only 2 index & creating on 2 index. So i manually drop the 3rd index which is not created by tools.
So, currently table PO_POA_HDR_HIST has 2 index count on psrecdefn table, 2 indexid in pskeydefn table, 2 entries in psindesxdefn table. (in dev environment )
while working on migration plan, we took the script & executed on QA environment.
so, the script is dropping the 3 index & creating 2 index