PLAN JOIN (HD_STATUS INDEX (HD_STATUS_IDX1), HD_OCORRENCIAS INDEX (FK_HD_OCORRENCIAS_STAT), ORDEM_SERVICO_DIVISAO INDEX (PK_ORDEM_SERVICO_DIVISAO), HD_PROBLEMAS INDEX (PK_HD_PROBLEMAS), CLIENTS INDEX(PK_STATUS)/*if the primary key is PK_STATUS, or you can use the index that is for the foreign key in HD_OCORRENCIAS */)