Forcing a sequential scan over the index scan

All we need is an easy explanation of the problem, so here it is. I have this query select s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment from part,supplier,partsupp,nation,region where p_partkey=ps_partkey and s_suppkey=ps_suppkey and s_nationkey=n_nationkey and n_regionkey=r_regionkey…

Continue ReadingForcing a sequential scan over the index scan