Loading...

XML

Word

Printable

JSON

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

Assigned Teams:

Query Optimization
Confidence Status:
None
Work Order:
3

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

nextReusableInputParamId linearly searches through all expressions stored so far for duplicates when parameterizing match expressions. This is slow for queries with a large number of predicates under an and/or. This blocks ~~SERVER-62509~~ from running all stress tests.

duplicates

SERVER-79092 Optimize the expression search for parameter reuse during parameterization

Closed

is related to

SERVER-62509 Write tests to stress ABT and Bonsai

Closed

Assignee:: [DO NOT USE] Backlog - Query Optimization
Reporter:: Matt Boros
Participants:: [DO NOT USE] Backlog - Query Optimization, David Storch, Matt Boros
Votes:: 0 Vote for this issue
Watchers:: 4 Start watching this issue

Created:: Jul 26 2023 09:12:30 PM UTC
Updated:: Jul 27 2023 03:21:23 PM UTC
Resolved:: Jul 27 2023 01:54:26 PM UTC