> 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.
Aglio Database Solutions
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-08-25 18:59:59|
|Subject: Re: "between" is using index but "like" is not |
|Previous:||From: Jesper Krogh||Date: 2004-08-25 13:30:50|
|Subject: "between" is using index but "like" is not|