Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: None
Labels:
None

Assigned Teams:

Query Optimization
CAR Domain/s:
None

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

For SERVER-120017, we need to be able to hint either INLJ or HJ to be used as the join algorithm. We should introduce a knob for this which forces the desired join algorithm. We should be able to leverage the hinting functionality implemented as part of SERVER-114582.

Note that this specific knob might become superfluous if we implement SERVER-120163, but we currently just need a way to force a specific algorithm.

is related to

SERVER-120017 Initial calibration of HJ vs INLJ

In Code Review

SERVER-114582 Add support for random reordering via the bottom-up enumerator

Needs Merge

SERVER-120163 Consider providing a more robust hinting mechanism

In Progress

Assignee:: Max Verbinnen
Reporter:: Max Verbinnen
Participants:: Max Verbinnen
Votes:: 0 Vote for this issue
Watchers:: 2 Start watching this issue

Created:: Feb 23 2026 05:56:10 PM UTC
Updated:: Mar 04 2026 02:43:55 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates