MySQL Forums
Forum List  »  Optimizer & Parser

My query take along time
Posted by: Murawweh Daher
Date: December 17, 2017 07:18AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
My query take along time
381
December 17, 2017 07:18AM
143
December 17, 2017 09:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.