Sql In Vs Exists

Exist return True or False.

Using IN is better when sub query contains small data.

Using Exist is better when sub query contains large data. 

select * from tbl where exists (select id from customer cust where cust.code=tbl.customercode)