Hi,
this two queries are supposed to return same

1) select cus_no from customer where cus_no not in (select cus_no from cust_history)

2) select cus_no from customer minus select cus_no from customer_hist

hovever first one takes ages to execute and second is done within minute (yes there are 10 millions rows in cust tables:-)

thank you