Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 9.1.0-rc0
Affects Version/s: None
Component/s: None
Labels:
- join-plan-cache

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

When inserting an entry into the cache we should also compute the relevant index set fingerprint by hashing the relevant indexes and their respective multikey states.

depends on

SERVER-132593 Introduce relevant index fingerprinting library for join plan cache

Closed

is depended on by

SERVER-132693 [Join Optimization] Expose index fingerprint in explain

Open

related to

SERVER-129266 [Join Optimization] Introduce Collection invalidation tags to join plan cache

Closed

SERVER-132446 Encode index ident into join plan cache node fingerprint and CachedJoinPlan

Open

SERVER-132787 [Join Optimization] Introduce query knob to control index fingerprint invalidation

Backlog

SERVER-132841 [Join Optimization] Avoid cache invalidation when a relevant but unused index is dropped

In Code Review

SERVER-132444 Codify INLJ eligible index reads to prevent duplicate work

Closed

(2 related to)

Assignee:: Naafiyan Ahmed
Reporter:: Naafiyan Ahmed
Participants:: Githook User, Naafiyan Ahmed
Votes:: 0 Vote for this issue
Watchers:: 3 Start watching this issue

Created:: Jul 01 2026 09:21:08 PM UTC
Updated:: Aug 06 2026 06:46:33 PM UTC
Resolved:: Aug 06 2026 06:46:33 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates

PagerDuty