On Thu, Dec 29, 2016 at 4:21 PM, Job <j...@colliniconsulting.it> wrote:
> 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? > GIST https://www.postgresql.org/docs/9.6/static/pgtrgm.html https://www.postgresql.org/docs/9.6/static/btree-gist.html David J.
