\timing on

select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;
select count(1) from (select * from f join d on (f.fact_id = d.dim_id)) foo;