[PERFORM] select on index column,why PG still use seq scan?

I create a table and insert some items. I create index on every column. And I execute select, I thought it should use index scan, but it is still seq scan. Why PG do not use index scan? create table v_org_info( org_no varchar2(8), org_nm varchar2(80), org_no_l1 varchar2(8), org_nm_l1 varchar2(80)

Re: [PERFORM] select on index column,why PG still use seq scan?

Xiaoyulei writes: > I create a table and insert some items. > I create index on every column. > And I execute select, I thought it should use index scan, but it is still seq > scan. Why PG do not use index scan? > create table v_org_info( > org_no varchar2(8), org_nm varchar2(80), > org_no_l1 va