Hello,
What is the difference in process speed if i use "in" operator
and "inner join".

Eg:
Select a.id from cust a,prod b where a.prod_id=b.prod_id

and

Select id from cust a where prod_id in (select prod_id from prod)


Regards,

Sivaraman