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/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
