Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
On Sun, 22 Jan 2023 at 13:34, aditya desai <admad123@gmail.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.
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 по дате отправления: