TPC-H查询
      TPC-H基准是一种用于决策支持的基准。这个基准测试大量数据（大约1GB数据），执行高度复杂的查询，并给出结果。

      在TPC-H测试结果中，Altibase显示了其强大的性能。而且，我们还在继续努力以提高我们的产品的性能。

如果您想了解TPC-H的详细信息，请查阅"New TPC Benchmarks for Decision Support and Web Commerce", "TPC BENCHMARKTM H Standard Specification Revision 1.3.0".

TPC-H基准测试由22种查询组成，下面列出其中的几种：

Q1:
        select
              l_returnflag,
              l_linestatus,
              sum(l_quantity) as sum_qty,
              sum(l_extendedprice) as sum_base_price,
              sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
              sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
              avg(l_quantity) as avg_qty,
              avg(l_extendedprice) as avg_price,
              avg(l_discount) as avg_disc,
              count(*) as count_order
        from
              lineitem
        where
              l_shipdate <= to_date('01-Dec-1998') - :ship_date
        group by
              l_returnflag,
              l_linestatus
        order by
              l_returnflag,
              l_linestatus;

Q2:
        select
               s_acctbal,
               s_name,
               n_name,
               p_partkey,
               p_mfgr,
               s_address,
               s_phone,
               s_comment
        from
               part,
               supplier,
               partsupp,
               nation,
               region
        where
               p_partkey = ps_partkey
               and s_suppkey = ps_suppkey
               and p_size =:a_count
               and p_type like :a_seg
               and s_nationkey = n_nationkey
               and n_regionkey = r_regionkey
               and r_name = :a_seg1
               and ps_supplycost = (
                      select
                             min(ps_supplycost)
                      from
                             partsupp,supplier,
                      nation,region
                      where
                             p_partkey = ps_partkey
                             and s_suppkey = ps_suppkey
                             and s_nationkey = n_nationkey
                             and n_regionkey = r_regionkey
                             and r_name =:a_seg1
                      )
        order by
               s_acctbal desc,
               n_name,
               s_name,
               p_partkey;

Q7:
        select
               n1.n_name as supp_nation,
               n2.n_name as cust_nation,
               extract(l_shipdate, 'year') as l_year,
               l_extendedprice*(1-l_discount) as volume
        from
               supplier,
               lineitem,
               orders,
               customer,
               nation n1,
               nation n2
        where
               s_suppkey = l_suppkey
               and o_orderkey =l_orderkey
               and c_custkey = o_custkey
               and s_nationkey = n1.n_nationkey
               and c_nationkey = n2.n_nationkey
               and(
                      (n1.n_name =:a_seg and n2.n_name=:a_seg1)
                      or (n1.n_name =:a_seg1 and n2.n_name= :a_seg)
                      )
               and l_shipdate between to_date('01-Jan-1995')and to_date('31-Dec-1996')
               ) as shipping

        group by
               supp_nation,
               cust_nation,
               l_year
        order by
               supp_nation,
               cust_nation,
               l_year;