Hi andrew,

Creating a computed column with the substring on the underlying table and indexing that and using it in the where clause instead of the original column should also work.

>>how...

Hi,

thanks a lot.

it will work fine with "like".

It is not possible to remove substring function because of application behavior.

Also you could consider not using the view at all since you apparently don't need the 3rd column in...

should I create another index based on the view?

In that case please send me the index creation steps.

Or is there any other way to make the query faster.

thanks

select query does not use indexes as there is a substring function and is slow.

I want to use index so that it become faster.

please suggest.

thanks