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 <mark@mielke.cc>