Posts Tagged ‘ tpch ’

Sometimes it is useful to sort the lineitem table, in the order that Query-6 will read the data back. Query-6 looks like so :- set timing on; select sum(l_extendedprice * l_discount) as revenue from lineitem where l_shipdate >= to_date( '1995-01-01', 'YYYY-MM-DD') and l_shipdate < add_months(to_date( '1995-01-01', 'YYYY-MM-DD'), 12) and l_discount between 0.07 - 0.01 and 0.07 + 0.01 and l_quantity < 25; exit; and...
Read more »