Re: Problem with LIKE-Performance

On 18.04.2006, at 17:16 Uhr, Tarabas (Manuel Rorarius) wrote:

> Is there any way to speed the like's up with a different locale than C
> or to get an order by in a different Locale although using the
> default C locale?

Sure. Just create the index with

create index <tabname>_<column>_index on <tabname> (<column>
varchar_pattern_ops);

Than you can use something like

select * from <table> where <column> like 'Something%';

Remember that an index can't be used for queries with '%pattern%'.

cug