[MDEV-23811] With large number of indexes optimizer chooses an inefficient plan - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7
Component/s: Optimizer
Labels:
- ServiceNow
Environment:
10.2

Description

With a large number of indexes the optimizer picks the wrong path.

Attachments

Issue Links

causes

MDEV-24117 Memory management problem in statistics state for queries that have a large field IN (values) part

Closed

Activity

People

Assignee:: Igor Babaev

Reporter:: Kyle Joiner

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2020-09-24 17:28

Updated:: Yesterday 21:46

Resolved:: 2020-10-08 17:45