My query take along time

[Murawweh Daher]

Hi All,

i have query take 58 second (query below), what must i do to enhance on database and enhance query fetch time.


SELECT count(adjustmentamount) totalRefill , DATE(airtimestamp) FROM air_drs a ,sdp_drs b
where b.ISDUPLICATED='1' and VOUCHERBASEDR='0' and REFILLPROFILEID='7'
and UPPER (a.extdata1) IN ('ADD', 'D_ADD') and upper(a.AIRRECORDTYPE)='REFILL'
and a.accounteventid = b.accounteventid group by DATE(airtimestamp)


Thanks.