Re: Nested Loop "Killer" on 8.1

[Mark Mielke <mark@xxxxxxxxxxxxxx>]

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@xxxxxxxxx>