Jesper,
> Why doesn't it use an index on the "like" operator when it doesn't contain
> a wildcard in the beginning of the pattern?
How many rows are there in the table? What happens if you force an index
scan on the 2nd query? Is this ASCII text or UNICODE text?
Normally LIKE 'xxx%' does use an index if it's useful, so there is something
else going on here.
--
Josh Berkus
Aglio Database Solutions
San Francisco