Re: same query, two different approaches, vastly different performance

On Feb 13, 2012, at 6:57 PM, David Nicol wrote:

> did you find
> 
> http://stackoverflow.com/questions/1566717/postgresql-like-query-performance-variations
> 
> in your research?


Thanks for that link, but I don't think that applies in my case. I have two exact queries, with a postfix wildcard search. One, I prepare with the search term embedded in the query. The other is prepared with a bind variable and the search term is added during $sth->execute.

The first one uses the index. The second does a full-table scan.

Strange, but true.



--
Puneet Kishor