asterixdb/asterix-app/src/test/resources/optimizerts/results/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan

-- DISTRIBUTE_RESULT  |PARTITIONED|
  -- SORT_MERGE_EXCHANGE [$$39(ASC) ]  |PARTITIONED|
    -- STABLE_SORT [$$39(ASC)]  |PARTITIONED|
      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
        -- STREAM_PROJECT  |PARTITIONED|
          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
            -- HYBRID_HASH_JOIN [$$36][$$37]  |PARTITIONED|
              -- HASH_PARTITION_EXCHANGE [$$36]  |PARTITIONED|
                -- ASSIGN  |PARTITIONED|
                  -- STREAM_PROJECT  |PARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      -- BTREE_SEARCH (test.tenk1.tenk1)  |PARTITIONED|
                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                          -- ASSIGN  |PARTITIONED|
                            -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
              -- HASH_PARTITION_EXCHANGE [$$37]  |PARTITIONED|
                -- ASSIGN  |PARTITIONED|
                  -- STREAM_PROJECT  |PARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      -- DATASOURCE_SCAN (test.tenk2)  |PARTITIONED|
                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|