HI every one application team informed that this query is taking more time than normal so from my end what should i do?
select xfrq.bay_user_id,xfrq.fr_acid,cusr.c_m_phone_no,cusr.c_email_id,xfrq.txn_amt,xfrq.end_date
from xfrq,cusr where xfrq.bay_user_id = cusr.bay_user_id
and xfrq.r_mod_id = 'FTONLDISP'and
datepart(dd,xfrq.r_mod_time)=13
and
datepart(mm,xfrq.r_mod_time)=04
and
datepart(yyyy,xfrq.r_mod_time)=2013
and
xfrq.res_code=000