On Thu, Dec 29, 2016 at 4:21 PM, Job <Job(at)colliniconsulting(dot)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.