Re: "like" and index

"Daniel J. Summers" <daniel@djs-consulting.com> writes:
> MySQL will only use it if the wildcard isn't in the front (1) and
> requires the MATCH keyword to search full-text indexes (2), Oracle
> requires special "full-text" indexes to be able to use for LIKE (3)
> (actually dealt with that at work a few months back), SQL Server only
> uses it under certain conditions (4), and even PostgreSQL (the great
> subject of this mailing list) doesn't do it with a standard index (5) -
> you've got to use a special operator class.

Only if you're using a non-C locale.

            regards, tom lane