optimizing LIKE '%2345' queries

Поиск
Список
Период
Сортировка
От Gene
Тема optimizing LIKE '%2345' queries
Дата
Msg-id 430d92a20607021450i1d228350j292d68e987ed58de@mail.gmail.com
обсуждение исходный текст
Ответы Re: optimizing LIKE '%2345' queries
Re: optimizing LIKE '%2345' queries
Список pgsql-performance
Is there any way to create a reverse index on string columns so that
queries of the form:

where column like '%2345';

can use an index and perform as fast as searching with like '2345%'?

Is the only way to create a reverse function and create an index using
the reverse function and modify queries to use:

where reverse(column) like reverse('%2345') ?

thanks

--
Eugene Hart
Cell: 443-604-2679

В списке pgsql-performance по дате отправления: