LIKE CLAUSE on VIEWS
aditya desai <admad123@gmail.com>
From: aditya desai <admad123@gmail.com>
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Date: 2023-01-22T11:33:46Z
Lists: 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.