On 06/25/2009 04:36 PM, Greg Stark wrote:
AND
    web_user_property_directory_outbox.prop_key like
'location_node_directory_outbox'

Why use "like" for a constant string with no % or _ characters? If you
used = the planner might be able to come up with a better estimate

Any reason why "like" with a constant string without % or _ is not optimized to = today?

Cheers,
mark

--
Mark Mielke<m...@mielke.cc>

Reply via email to