select h.id, d.ware_id
from doc_list h
join doc_data d on h.id=d.doc_id
where
    h.optype_id = 2000
    and h.state_id = 2000

PLAN JOIN (D NATURAL, H INDEX (PK_DOC_LIST))
18036 records fetched
    9451 ms, 5786789 fetch(es) 

Table                             Natural     Index  
*****************************************************
DOC_LIST                                     775923
DOC_DATA                           775923

PLAN JOIN (H INDEX (FK_DOC_LIST_OPTYPES, FK_DOC_LIST_STATE), D INDEX (FK_DOC_DATA_DOC_LISTS))
18036 records fetched
      49 ms, 37008 fetch(es) 

Table                             Natural     Index    Update    Insert    Delete   Backout   
**********************************************************************************************
DOC_LIST                                        133
DOC_DATA                                      18036