Performance issues related to left join and order by

2021-03-02 Thread Liu, Xinyu
Hello, We have 2 TPC-H queries which fetch the same tuples but have significant query execution time differences (22.0 times). We are sharing a pair of TPC-H queries that exhibit this performance difference: First query: SELECT"orders3"."o_comment", "orders3"."o_orderstatus",

Potential performance issues related to group by and covering index

2021-03-02 Thread Liu, Xinyu
Hello, We have 2 TPC-H queries which fetch the same tuples but have significant query execution time differences (4.3 times). We are sharing a pair of TPC-H queries that exhibit this performance difference: First query: SELECT "ps_comment", "ps_suppkey", "ps_supplycost",