Hi,
Is there any way to improve performance of LIKE clause on VIEWS.
select * From request_vw where upper(status) like '%CAPTURED%' - 28 seconds.
select * from request_vw where status='CAPTURED'
Application team is reluctant to change queries from the Application side
to = instead of LIKE.
Also as this is VIEW TRIGRAM nor normal indexes don't get used.
Regards,
Aditya.