[MDEV-35856] MySQL 8-style optimizer hints: milestone 2: index hints - Jira

XML

Word

Printable

Details

Type: New Feature
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Fix Version/s: 12.1.1
Component/s: Optimizer
Labels:
- Preview_12.1
- optimizer-12.1-sprint

Sprint:
Q2/2025 Development, Q3/2025 Maintenance, Q3/2025 Server Development
PM Planning:

Description

Implement needed hints that were not implemented in

Milestone 1 - BKA, MRR, ICP (~~MDEV-35504~~)
Join order hints (~~MDEV-34870~~ )
Subquery hints (~~MDEV-34888~~).

or not handled separately:

DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN - Moved into ~~MDEV-36106~~.
MERGE, NO_MERGE - Moved into ~~MDEV-36106~~

What remains are index usage control hints:

ORDER_INDEX, NO_ORDER_INDEX
- Documented here: https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints?q=force+index#order_index-and-no_order_index
GROUP_INDEX, NO_GROUP_INDEX
- Documented here: https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints?q=force+index#group_index-and-no_group_index
JOIN_INDEX, NO_JOIN_INDEX
- Documented here: https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints?q=force+index#join_index-and-no_join_index
INDEX, NO_INDEX
- Documented here: https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints?q=force+index#index-and-no_index

Attachments

Issue Links

causes

MDEV-37240 In queries with the INDEX() hint, "force index()" is ignored

Closed

MDEV-37292 Hint NO_INDEX() disables all indexes if none of given index names is resolved

Closed

is part of

MDEV-28906 MySQL 8.0 desired compatibility

Open

split from

MDEV-33281 Implement optimizer hints like in MySQL 8

Closed

Activity

People

Assignee:: Oleg Smirnov

Reporter:: Sergei Petrunia

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2025-01-15 11:53

Updated:: 5 days ago 01:00

Resolved:: 2025-08-04 19:16

Time Tracking

Estimated:

10d

Remaining:

0d

Logged:

20d 7h 26m

Git Integration

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