[MDEV-32358] Improve optimizer cost model to take ICP cost (and benefits) into account Created: 2023-10-05  Updated: 2023-10-30

Status: Open
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: None

Type: Task Priority: Major
Reporter: Valerii Kravchuk Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29151 Index choice depends on index definit... Closed
relates to MDEV-29121 Optimizer does not use the index for ... Open

 Description   

Currently optimizer does not take ICP benefits into account and this may lead to suboptimal index choice (see MDEV-29151 for the related examples and discussion), while forcing the index that can be used for ICP provides a notably faster execution for the query.

 Comments   
Comment by Oleg Smirnov [ 2023-10-06 ]

See this comment at MDEV-29151.

Generated at Thu Feb 08 10:30:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.