[jira] [Created] (IGNITE-25129) Calcite. TPC-H query #5: performance drop on scale 0.01

[Vladimir Steshin (Jira)]

Vladimir Steshin created IGNITE-25129:
-----------------------------------------

             Summary: Calcite. TPC-H query #5: performance drop on scale 0.01
                 Key: IGNITE-25129
                 URL: https://issues.apache.org/jira/browse/IGNITE-25129
             Project: Ignite
          Issue Type: Bug
            Reporter: Vladimir Steshin


`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
```
    Benchmark             (engine)  (queryId)  (scale)  Mode  Cnt    Score     
Error  Units
    TpchBenchmark.cached        H2          5     0.01  avgt    3  146.985 ± 
120.338  ms/op
    TpchBenchmark.cold          H2          5     0.01    ss       805.308      
      ms
```

Current code shows:
```
    Benchmark             (engine)  (queryId)  (scale)  Mode  Cnt     Score     
Error  Units
    TpchBenchmark.cached   CALCITE          5     0.01  avgt    3   619.041 ± 
216.738  ms/op
    TpchBenchmark.cold     CALCITE          5     0.01    ss       1786.908     
       ms/op
```

Workarounds: `/*+ ENFORCE_JOIN_ORDER */`, `/*+ NO_NL_JOIN +/`



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