Re: Better SQL performance than SUBSTRING

[Dan <dan27649@xxxxxxxxx>]

I've never done this for performance reasons and this is just a WAG, but
what about creating a view that includes a new field that is a substring
per your example?  It would still be a substring, but would performance be
better since it's defined in a view?

- Dan

On Fri, May 4, 2018 at 10:16 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

> I know that a LIKE performs better than a SUBSTRING in a SQL WHERE
> clause.  Is there a better option than a SUBSTRING for checking specific
> positions in a column?
>
> Given MY_TABLE with MY_COLUMN defined as char(12) and this query:
> Select *
>   From MY_TABLE
>   Where substring(MY_COLUMN, 5, 6) = '123456';
>
> Is there an alternative to SUBSTRING that will perform better?