I have a SQL Server view that times out every time that I run it. I am executing the following statement to retrieve data from the view:
SELECT * FROM vwMyView
WHERE MyDateField Between '1/1/2014' And '1/31/2014'
And MyField1 = '1-0' And MyField2 >=1000000 AND MyField3 IS NULL
When I execute this statement without the date criteria it returns records immediately. I have an index on the date field, so I don't understand why it is timing out.