[ASTERIXDB-3349] Indexnl hint not honored with CBO.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Vijay Sarathy
• Reporter: Vijay Sarathy
• Created: 31/Jan/24 19:57
• Updated: 02/Feb/24 18:05
• Resolved: 01/Feb/24 18:45

Description

The indexnl hint is not honored for the following query. The plan contains two hash joins and no index nested loops join between R and S.

select count(1) from R join S on  int64_default_null(R.u64) /*+ indexnl */  =  (S.u64)
join T on S.u256  /*+ hashjoin build (T) */ = T.u256