Improve sql query perf
Hi Gurus,
Any suggestion to improve this query
select arr.report_id,arr.vac_ref,ar.applicant_id,ar.review_login_id,ar.review_login_pwd,ar.review_complete_flag,ar.status,a.application_ref,
a.application_id,to_char( a.completion_date, 'dd/mm/yyyy' ) as application_date,a.sequence_number,decode( ar.status, 'COMPLETE', 3, 'MAILSENT', 2, 'SENDMAIL',
2, 'IN_PROGRESS', 1, 0 ) as status_order,nvl( a.offline_app_flag, 'N' ) as offline_app_flag from
ams_review_report arr inner join ams_review ar on ar.report_id = arr.report_id inner join
application a on ar.applicant_id = a.applicant_id and arr.vac_ref = a.vac_ref where ar.review_login_id in (39506227)
Any suggestion to improve this query
select arr.report_id,arr.vac_ref,ar.applicant_id,ar.review_login_id,ar.review_login_pwd,ar.review_complete_flag,ar.status,a.application_ref,
a.application_id,to_char( a.completion_date, 'dd/mm/yyyy' ) as application_date,a.sequence_number,decode( ar.status, 'COMPLETE', 3, 'MAILSENT', 2, 'SENDMAIL',
2, 'IN_PROGRESS', 1, 0 ) as status_order,nvl( a.offline_app_flag, 'N' ) as offline_app_flag from
ams_review_report arr inner join ams_review ar on ar.report_id = arr.report_id inner join
application a on ar.applicant_id = a.applicant_id and arr.vac_ref = a.vac_ref where ar.review_login_id in (39506227)
0