using sql 2008 R2.
I have a query which runs in less then 1 sec.
I created a view with the same sql and run this view with the same where clause that I am using with the query above, but it took over 7 minutes. Why is my view so slow if the query performance is good? Any ideas?