Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slow pervasive query

Status
Not open for further replies.

EasyBoy2

Technical User
Dec 22, 2015
2
CA
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?

select a.reqnum, a.reqdate, b.patientid, b.patcob, b.patdob, b.patsex, c.testcode, c.normalresult from "HiReq" as a

inner join "Patient" as b on a.patientid = b.patientid and b.patsex = 'M'

inner join "Hitest" as c on a.reqnum = c.reqnum and c.testcode = '903'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top