Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> TODO: add LIKE optimization to use = if constant does not contain any wildcards
Your information is obsolete ... try looking at the EXPLAIN VERBOSE
output for such a query.
regards, tom lane
---
> Can someone explain why the following query takes 1 second when using
> LIKE and takes 30 seconds when replacing LIKE by = in the WHERE ?
Because there is no optimization built in, that notices, that your
string does not contain a wildcard and would translate the restriction
corresponding
