Skip site navigation (1)
Skip section navigation (2)
In 8.1, what is the best way to index large text/varchar fields for wild card searches?
I am getting good number of queries being submitted for reporting purposes that are doing the following - where <text/varchar field> like '%some phrase%' and ....
Is there a good way to index these fields so that the db engine will use and index?
Thanks,
Chris
Peripheral Links
Header And Logo
|
Site Navigation
Best way to index large text/varchar fields
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Best way to index large text/varchar fields
- Date: Fri, 9 Jun 2006 11:45:23 -0400
In 8.1, what is the best way to index large text/varchar fields for wild card searches?
I am getting good number of queries being submitted for reporting purposes that are doing the following - where <text/varchar field> like '%some phrase%' and ....
Is there a good way to index these fields so that the db engine will use and index?
Thanks,
Chris
- Follow-Ups:
- Re: Best way to index large text/varchar fields
- From: Joshua D. Drake
- Re: Best way to index large text/varchar fields
- Prev by Date: Re: How to set the global OID counter? COPY WITH OIDS does
- Next by Date: Re: pg_dumpall 8.1.4 large objects error
- Previous by thread: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- Next by thread: Re: Best way to index large text/varchar fields
- Indexes: