[ASTERIXDB-3525] Utilize secondary indexes with LIKE operator

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.10
• Fix Version/s: 0.9.10
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Unassigned
• Reporter: Murtadha Makki Al Hubail
• Created: 06/Nov/24 21:57
• Updated: 21/Nov/24 22:04

Description

We should utilize secondary indexes when LIKE operator is used at least for the prefix cases (e.g., WHERE some_field LIKE "prefix%")