intersystems / intersystems/ipm

For updates, need to hold onto to tune table metadata (automatic exports/imports)

Open
#862 0 comments 1 reaction 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.