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