Hi Expert,
Following sql query is causing slowness.I wanted to know the source of this query :
select all tmf_loan_document.r_object_id,
tmf_loan_document.r_object_type,
tmf_loan_document.i_vstamp,
dm_repeating.r_aspect_name,
tmf_loan_document.i_is_replica,
tmf_loan_document.i_is_reference,
tmf_loan_document.rcu_status
from tmf_loan_document_sp tmf_loan_document,
dm_sysobject_r dm_sysobject_r2,
dm_folder_r dm_folder_r1,
tmf_loan_document_rp dm_repeating
where (tmf_loan_document.r_object_id = dm_sysobject_r2.r_object_id and
dm_sysobject_r2.i_folder_id = dm_folder_r1.r_object_id and
dm_folder_r1.i_ancestor_id = '0b0000de85e5e5b5' and
(( trim(tmf_loan_document.object_name) = 'Aadhaar Card')) and
((tmf_loan_document.r_object_type = 'tmf_loan_document')))
and (tmf_loan_document.i_has_folder = 1 and
tmf_loan_document.i_is_deleted = 0)
and ((tmf_loan_document.owner_name in
('rspm_quote_app_user', 'dm_world', 'rspm_group')) or
(exists
(select '1'
from dm_acl_s ACL_S0, dm_acl_r ACL_R
where ACL_S0.r_object_id = ACL_R.r_object_id
and tmf_loan_document.acl_domain = ACL_S0.owner_name
and tmf_loan_document.acl_name = ACL_S0.object_name
and ((ACL_R.r_accessor_name in ('rspm_quote_app_user', 'dm_world') or
(ACL_R.r_is_group = 1 and
(ACL_R.r_accessor_name in
('rspm_quote_app_user', 'dm_world', 'rspm_group')))) and
((ACL_R.r_permit_type = 0 or
ACL_R.r_permit_type is null) and
(((ACL_R.r_accessor_permit >= 2))))))))
and dm_repeating.r_object_id = tmf_loan_document.r_object_id
order by 1
Kindly suggest.
