[
https://issues.apache.org/jira/browse/IGNITE-26068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky reassigned IGNITE-26068:
-------------------------------------------
Assignee: Evgeny Stanilovsky
> Sql. Update cached query plans when related statistics changed
> --------------------------------------------------------------
>
> Key: IGNITE-26068
> URL: https://issues.apache.org/jira/browse/IGNITE-26068
> Project: Ignite
> Issue Type: Improvement
> Components: sql ai3
> Reporter: Konstantin Orlov
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> Currently, cached query plans are never invalidated unless they are evicted
> due to size-based eviction policy. This may cause suboptimal query execution
> when data changes significantly.
> Let's address this issue by adding automatically plan re-optimization on
> statistic change. Things to keep in mind:
> * Query plan cache may contains hundreds of plan which may get outdated at
> once. Re-optimization task must not occupy entire planning pool, so newly
> arrived queries should be prepared with priority.
> * Query may involve multiple tables. There should be at most one
> re-optimization task scheduled at a time.
> * Plan cache may contain entries for an old catalog version. Such entries may
> be skipped because right now they will lead to re-optimization anyway when
> the same query arrive within new transaction.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
