Query Runs Fast, but View is very SLOW - HELP!!!

[hneal98]

Hi I have a view where if I run the query with in it, it runs in 3 seconds, but if I try to run the view, it seems to never end.

Any ideas as t why this might happen?

Thanks,

Harvard

 

[monksnake]

I came across this:

http://www.sql-server-performance.com/views.asp

<.

 

[ptheriault]

Can you post the view?

- Paul

- If at first you don't succeed, find out if the loser gets anything.