Best way to index large text/varchar fields
От
Chris Hoover
Тема
Best way to index large text/varchar fields
Дата
Msg-id
1d219a6f0606090845q62fad204m95e526effb35fba1@mail.gmail.com
Список
Дерево обсуждения
Best way to index large text/varchar fields "Chris Hoover" <revoohc@gmail.com>
Re: Best way to index large text/varchar fields "Joshua D. Drake" <jd@commandprompt.com>
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
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
В списке pgsql-admin по дате отправления
От: Dirk Lutzebäck
Дата:
