Loading...

XML

Word

Printable

JSON

Type: Task
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 9.0.0-rc0
Affects Version/s: None
Component/s: None
Labels:
None

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

Now that we have the calibration infrastructure set up (~~SERVER-119383~~), we can start the actual calibration of HJ vs INLJ. This will include finding the tipping point between the two algorithms.

blocks

SERVER-121215 Cost of INDEX_PROBE_NODE does not take into account number of index keys visited per 1 probe

Open

SERVER-121272 Exorbitant cost calculated for INDEXED_NESTED_LOOP_JOIN_EMBEDDING, inferior plan selected

Open

SERVER-121283 HASH_JOIN_EMBEDDING stage is costed as if almost free

Open

related to

SERVER-119849 Q3 investigation

Closed

SERVER-119383 Build join test suite for tuning of join costing

Closed

SERVER-120187 Add query knob to force specific join algorithm

Closed

(1 related to)

Assignee:: Max Verbinnen
Reporter:: Max Verbinnen
Participants:: Githook User, Max Verbinnen
Votes:: 0 Vote for this issue
Watchers:: 4 Start watching this issue

Created:: Feb 20 2026 10:57:28 AM UTC
Updated:: Mar 20 2026 09:41:50 AM UTC
Resolved:: Mar 20 2026 09:26:54 AM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates