Use Exists instead of IN

dont use : 27 seconds

select count(*) from pro 
where pro_id in
( select  pro_id from sales)

OK : 20 seconds

select count(*) from pro p
where exists
      ( select 1 from sales s
          where s.pro_id=c.pro_id

*

index should be created in different tablespace with table