Any idea why using a variable v_streetName instead of a string 'wynn%' behaves differently?
Yeah.
'wynn%' doesn't start with % so LIKE uses index.
But Postgres doesn't know that you know that the contents of this
variable never starts with '%'...
Thanks, John
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
