hi friends,

if i use the following query it hangs.

select * from rm_stkfile where piece_no not in(
select piece_no from rm_purdetl);

here rm_purdetl table consistis of around 74000 rows.
rm_stkfile consists of around 50000 rows.
piece_no is common column in both tables.

what is alternate solution for this.

thanks