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
