sql语句怎么优化

select distinct r.farmer_no, r.allowance_money ,f.farmer_name ,c.allowance_name from hn_allowance_record01 r  ,HN_FARMER f, HN_CATEGORY c   where r.farmer_no=r.farmer_no  and r.CREATE_DATE in (select  r.CREATE_DATE from hn_allowance_record01 r where   r.CREATE_DATE >='2018-06-06 21:15:30'  or r.CREATE_DATE < '2018-03-02 00:00:00') and c.ALLOWANCE_NO in (select ALLOWANCE_NO from HN_CATEGORY ) ;

查询共有125多万条   求大老教优化