Shulou(Shulou.com)06/03 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.