Loading...

XML

Word

Printable

JSON

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

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
Linked BF Score:
200
CAR Domain/s:
None

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

~~SERVER-119438~~ implemented a buffer aware formula for the number of random I/Os performed in an INLJ. We should extend this to regular index scans, but must deal with multikey indexes.

blocks

SERVER-118886 Join optimization: cost estimate for FETCH is incorrect

Closed

is duplicated by

SERVER-120013 Join optimization: estimateMackertLohmanRandIO() expected numPagesColl > 0 with an empty table

Closed

is related to

SERVER-119438 [Join Optimization] Buffer aware index probe cost formula

Closed

related to

SERVER-119851 Q7 investigation

Closed

SERVER-119852 Q8 investigation

Closed

Assignee:: Ben Shteinfeld
Reporter:: Ben Shteinfeld
Participants:: Ben Shteinfeld, Githook User
Votes:: 0 Vote for this issue
Watchers:: 2 Start watching this issue

Created:: Feb 17 2026 05:01:40 PM UTC
Updated:: Feb 24 2026 05:59:11 PM UTC
Resolved:: Feb 20 2026 04:59:04 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates