Special index for "like"-based query

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Special index for "like"-based query
Date: 2016-12-29 23:21:11
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE7@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

in Postgresql 9.6 we have a query running on a very large table based, in some cases, on a like statement:

... WHERE FIELD='CODE' OR FIELD LIKE 'CODE_%'

Which type of index can i create to speed to the search when the "like" case happens?

Thank you!
/F

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2016-12-29 23:32:17 Re: Performance PLV8 vs PLPGSQL
Previous Message Gavin Flower 2016-12-29 23:05:10 Re: Performance PLV8 vs PLPGSQL