Are the two uses of the query identical? "Select * from MyView" vs just running the exact query in the view without modification?
If so, have you checked for blocking issues when you run the view and it takes forever?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon