intersystems / intersystems/ipm
For updates, need to hold onto to tune table metadata (automatic exports/imports)
- Dominant language
- ObjectScript
- Stars
- 41
- Forks
- 29
- Avg merge
- 23h 54m
- Merged PRs (30d)
- 4
Description
Problem Summary:
In IRIS, table statistics ("tune tables") influence the SQL optimizer by providing data about the rarity of index values and other distribution metrics. These statistics are tied to the class definitions of persistent tables.
During an upgrade or module update, new class definitions often overwrite the old ones. This can cause the associated table statistics to be lost, particularly for large tables where these statistics are critical to ensuring efficient query plans.
Proposed Solution:
Enhance the %Reload phase for module updates to automatically:
1. Inspect persistent data for the module being updated.
2. Export relevant table statistics metadata (tune table data) for affected persistent classes before recompilation.
3. Re-import the saved statistics after the classes are recompiled, restoring the optimizer’s expected behavior immediately after the upgrade.
Contributor guide
Assessment
This issue has not been assessed yet.