Re: [PERFORM] Problem with LIKE-Performance

[Guido Neitzer]

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



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

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

smime.p7s
Description: S/MIME cryptographic signature