LIKE CLAUSE on VIEWS

[aditya desai <admad123@xxxxxxxxx>]

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.