I have a view that executes fine. It returns about a million records and executes in a couple seconds. The problem I am having is that if I query the view with a filter it executes very slowly. About a row per second - so it would take forever to complete.
This works fine...
But this does not...
WHERE (Project = N'12-282')
In addition, if I add the filter directly to the view query then it will work fine. I just won't work if I append a filter to a SELECT against the view.
I hope this is clear enough. Does any understand what is happening?