Skills of SPL performance Optimization from TPCH Test
Test environment description
CPU:4, dominant frequency 2.6G, the number of cores per CPU is 8.
Hard disk: 800G SAS 15000 rpm hard disk, theoretical read and write speed 150m/s.
Memory: 64GB.
Operating system: Linux cent os 6
SQL1
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
