hash join驱动表问题

explain plan for select c.oper_no, a.passbook_no, g.acct_no  
   from auto_savb_acct  g,
        auto_savb_acct  a,  
        (select * from comc_branch where substr(ctrl_bit,7,1)='0' )b,  
        auto_comc_clerk c,  
        comc_clerk_post d         
  where a.media_type = '3'  
    and substr(a.draw_mode, 1, 1) = '1'  
    and substr(a.status, 1, 1) = '0'  
    and g.media_type = '1'  
    and a.flag = '0'  
    and g.flag = '0'  
    and c.flag = '0'  
    and a.cur_code = 1  
    and g.cur_code = 1  
    and g.open_bran_code = c.bran_code  
    and a.open_bran_code = c.bran_code 
    and substr(g.status, 1, 1) = '0'  
    and c.post_no = d.post_no  
    and d.trans_code = '104106'  
    and c.bran_code=b.bran_code  
    and rownum < 2 ;
    
    select * from table(dbms_xplan.display());


 
Plan hash va