#11822 Added missing indexes for GP historical snapshot
Added missing indexes to three GP historical snapshot staging tables to improve query performance during data migration.
- 3files
- 3AL files
- 3objects
Pull request · merged into main (BC30) on 2026-09-30 by jaymckinney-enavate (community contribution) · 3 files (+9 -0), 3 AL · performance · tier official · reviewed (checked by Opus)
What changed
- New index on CUSTNMBR, APTODCTY, APTODCNM added to GP RM20201 and GP RM30201
- New index on IVDOCTYP, DOCNUMBR, LNSEQNBR added to GPIVSerialLotNumberHist
- Only key definitions added; no logic changes
- Affects HybridGP historical snapshot staging tables
AL objects touched
- Table 4038 “GPIVSerialLotNumberHist”, HybridGP: modified
- Table 40144 “GP RM20201”, HybridGP: modified
- Table 40145 “GP RM30201”, HybridGP: modified
Context
- Fixes: #11800 [Bug]: Missing indexes in GP migration historical snapshot (closed)
- Work items: AB#652333
- Labels: ADO: Sync, AL: Apps (W1), From Fork, Team: Integrations
- Systems: development
- From the description: “This PR adds missing indexes to the following GP historical snapshot related staging tables.”
Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).