[Issue] Improve price index consistency and run time

[m2-assistant]

This issue is automatically created based on existing pull request: #35524: Improve price index consistency and run time

---

Description (*)

With a very large product set (~213k) on 1 of our sites, the price index (and through the use of MSI, the inventory index) takes a very long time to complete, with multiple hours spent executing deleteIndexData. It seems the primary cause of this slowdown is string to int conversions or vice versa in MySQL, and ensuring that all IDs are integers beforehand yields much more consistent and reasonable performance on these larger sets

Manual testing scenarios (*)

1. Get a bunch of products
2. Use MSI
3. Have multiple stock sources (with a non default providing most of the stock)
4. Run an inventory index (the issue is most noticeable here due to InventoryCatalog's plugin "PriceIndexUpdatePlugin", and its call to reindexList with a very large number of IDs)

Contribution checklist (*)

• [✓] Pull request has a meaningful description of its purpose
• [✓] All commits are accompanied by meaningful commit messages
• [✓] All new or changed code is covered with unit/integration tests (if applicable)
• [✓] README.md files for modified modules are updated and included in the pull request if any README.md predefined sections require an update
• [✓] All automated tests passed successfully (all builds are green)

[github-jira-sync-bot]

✅ Jira issue https://jira.corp.magento.com/browse/AC-5887 is successfully created for this GitHub issue.

[m2-assistant]

✅ Confirmed by @engcom-Alfa. Thank you for verifying the issue.
Issue Available: @engcom-Alfa, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.