[IGNITE-14927] Change the index cost model

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Taras Ledkov
• Reporter: Taras Ledkov
• Created: 17/Jun/21 14:13
• Updated: 09/Mar/22 13:08
• Resolved: 09/Mar/22 13:08

Description

Current cost model of the index is designed for 2.x indexes where IndexScan is cheaper than TableScan because index storage uses direct link to data pages.

At the Ignite 3.0 index uses a primary key as the reference to the data row. So additional lookup by the PK is required.

Issue Links

• is part of: IGNITE-14925 Sorted indexes engine
• links to: GitHub Pull Request #701
• links to: PR #701