set enable_global_stats = true;
set current_schema=vector_engine;
set enable_vector_engine=on;
set enable_nestloop=off;
explain (costs off) select
	sum(l_extendedprice * l_discount) as revenue
from
	lineitem
where
	l_shipdate >= '1994-01-01'::date 
	and l_shipdate < '1994-01-01'::date + interval '1 year'
	and l_discount >= 0.06 - 0.01
    and l_discount <= 0.06 + 0.01
	and l_quantity < 24;

select
	sum(l_extendedprice * l_discount) as revenue
from
	lineitem
where
	l_shipdate >= '1994-01-01'::date 
	and l_shipdate < '1994-01-01'::date + interval '1 year'
	and l_discount >= 0.06 - 0.01
    and l_discount <= 0.06 + 0.01
	and l_quantity < 24;