LIKE CLAUSE on VIEWS

Поиск
Список
Период
Сортировка
От aditya desai
Тема LIKE CLAUSE on VIEWS
Дата
Msg-id CAN0SRDEHJUE79tS-=x19emW9tUd7F25Y-WCwsZD2taZdCpsEug@mail.gmail.com
обсуждение исходный текст
Ответы Re: LIKE CLAUSE on VIEWS
Re: LIKE CLAUSE on VIEWS
Список pgsql-performance
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.

В списке pgsql-performance по дате отправления: