On Tue, 26 Nov 2024 at 09:55, Ba Jinsheng wrote:
> TPC-DS query 95:
> Its execution time is nearly 1 min:
>CTE ws_wh
> -> Hash Join (cost=37772.14..198810.77 rows=7242361 width=12) (actual
> time=211.161..1443.926 rows=6644004 loops=1)
> If applying this patch:
> - if (is_inne
Hi all,
Please see this case.
TPC-DS query 95:
with ws_wh as
(select ws1.ws_order_number,ws1.ws_warehouse_sk wh1,ws2.ws_warehouse_sk wh2
from web_sales ws1,web_sales ws2
where ws1.ws_order_number = ws2.ws_order_number
and ws1.ws_warehouse_sk <> ws2.ws_warehouse_sk)
select
count(distinct
