Hi,

Thanks for the input, is this correct approach,

In my VIEW, vMyTable

select col1,

isnull(column50,1) as column50,

column51

from dbo.MyTable

where Column50 = 1

In the MyTable indexes, I added the following script

create nonclustered index ixIndex_Column50 on...

was able to improve the query by moving the isnull to the select and adding the column to a filtered index. Was able to reduce query time from 9+ min...

the data is binded to a asp.net gridview.

I am measuring the time on SSMS.

currently added non-unique, non-clustered index and filter index

I got the 9 min query time without index and using ISNULL in the where

but so far, I change the where clause and...