LIKE CLAUSE on VIEWS

Поиск
Список
Период
Сортировка
От aditya desai
Тема LIKE CLAUSE on VIEWS
Дата
Msg-id CAN0SRDEHJUE79tS-=x19emW9tUd7F25Y-WCwsZD2taZdCpsEug@mail.gmail.com
обсуждение исходный текст
Ответы Re: LIKE CLAUSE on VIEWS  (Samed YILDIRIM <samed@reddoc.net>)
Re: LIKE CLAUSE on VIEWS  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: aditya desai
Дата:
Сообщение: Re: ALTER STATEMENT getting blocked
Следующее
От: Samed YILDIRIM
Дата:
Сообщение: Re: LIKE CLAUSE on VIEWS