Slow pervasive query

Slow pervasive query

Slow pervasive query

I really dont have any knowledge about pervasive database. We have one simple query which is running very slow (taking ages). I have created index on HiReqe (patientid,reqnum, reqdate), patient (patientid, patsex, patcob,patdob) and hitest (reqnum, testcode). Is there anything that i can do run query faster?