Thread: Best way to index large text/varchar fields

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

Chris Hoover wrote:
> 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?

If you are indeed using phrases, and thus paragraphs of text, you should
look into Tsearch2.

Joshua D. Drake

>
> Thanks,
>
> Chris


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/