>
>
> On Sun, 22 Jan 2023 at 13:34, aditya desai <admad123(at)gmail(dot)com> wrote:
>
>> 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.
>>
>
You could try using the `text_pattern_ops` operator class on your index on
the `status` column:
https://www.postgresql.org/docs/current/indexes-opclass.html