[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:
None
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

mentioned in: Page Loading...

Activity

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Kyle Joiner

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2020-09-24 17:28

Updated:: 2024-09-06 10:01

Resolved:: 2020-10-08 17:45

Time Tracking

Estimated:

Not Specified

Remaining:

0d

Logged:

4d 7.33h

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.