I like to get records comparing two tables using mysql query as follows:
select * from tblbf where (rcpt_no not in (select ref_no from tblaccounts))
Note: tblbf is having 20000 records and tblaccounts having 40000 records.
(tblaccounts is not indexed but tblbf is having primary key)
Its taking too long time to show the result.
Any idea to get quick result.?