optimizing LIKE '%2345' queries
От
Gene
Тема
optimizing LIKE '%2345' queries
Дата
Msg-id
430d92a20607021450i1d228350j292d68e987ed58de@mail.gmail.com
Список
Дерево обсуждения
optimizing LIKE '%2345' queries Gene <genekhart@gmail.com>
Re: optimizing LIKE '%2345' queries Mario Weilguni <mweilguni@sime.com>
Is postgresql ca do the job for software deployed in ASP ou SaaS mode? David Gagnon <dgagnon@siunik.com>
Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? "Chris Hoover" <revoohc@gmail.com>
Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? "Guoping Zhang" <guoping.zhang@nec.com.au>
Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Richard Broersma Jr <rabroersma@yahoo.com>
Re: Is postgresql ca do the job for software deployed in "Craig A. James" <cjames@modgraph-usa.com>
Re: optimizing LIKE '%2345' queries Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
Re: optimizing LIKE '%2345' queries Gene <genekhart@gmail.com>
Re: optimizing LIKE '%2345' queries Chris <dmagick@gmail.com>
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 по дате отправления
