You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Vijay Sarathy (Jira)" <ji...@apache.org> on 2024/02/01 18:46:00 UTC

[jira] [Resolved] (ASTERIXDB-3349) Indexnl hint not honored with CBO.

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vijay Sarathy resolved ASTERIXDB-3349.
--------------------------------------
    Resolution: Fixed

> Indexnl hint not honored with CBO.
> ----------------------------------
>
>                 Key: ASTERIXDB-3349
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3349
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Vijay Sarathy
>            Assignee: Vijay Sarathy
>            Priority: Major
>
> 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.
> {code:java}
> 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
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)